Queries

This context is a container, holding all queries for a particular user.

Unique Actions

[?]

Execute Native Query

This Call Function action is used to execute a native SQL query on a Iotellect Server relational database. It calls the Execute Native Query function from the root context.

Queries executed by this action affect the underlying Iotellect Server database directly, bypassing the Iotellect Server Query Language engine and Iotellect Server permission checking. Incorrect queries may corrupt the data and make Iotellect Server installation non-operative.

The Execute Native Query action can only be successfully executed if the Iotellect Server database being queried is a relational database.

Action Type:

Call Function

Action Name:

executeNativeQuery

Permissions:

Accessible at Administrator permission level

Create Query

(Default Action)

This action is used for creating new queries. It allows user to specify basic properties of the new query and configure it immediately after creation.

Action Type:

Create

Permissions:

Accessible at Manager permission level

Common Actions

[?]

Create From Template, Replicate To Children, Import, Export, Edit Context Permissions, Monitor Related Events, Search/Filter, various Grouped Actions according to child contexts.

[?]

Create Query

This action creates a new query that selects:

  • Value of this variable from multiple contexts, or

  • History of this variable, or

  • Statistics of this variable

Action workflow:

  • Select what the query should be based on: current values of the variable, variable history, or variable statistics. This will form the FROM clause of the query.

  • If variable history was selected at step 1, select a time frame to extract the historical data for: all time or specific time frame.

  • If specific time frame was selected at step 2, define a range of historical/statistical data to include in the query results.

  • If variable statistics was selected at step 1, select a statistical channel those data will be included in the query results. The query creation will be finished at this point.

  • Select a resource or mask of resources that the query should select data from. This resource/mask will be included in the FROM clause.

  • If a single-row variable initially selected to build the query, choose between building a query over a single variable or multiple variables. The variables will be listed in the FROM clause of the query.

  • If multiple variables were selected at step 6, select some other single-row variables to include in the query results.

  • Select what variable fields to include in the query results: all fields of selected variables or selected fields only. The fields will be listed in the SELECT clause of the query.

  • If selected fields option was chosen at step 8, check one or more fields to include in the query results.

  • Add one or more conditions to the WHERE clause of the query. Each condition is defined by a variable, a comparison operation, a string-encoded value to compare the variable to, and an OR/AND operation applied to the other conditions.

  • The query is created at this point and its configuration is opened for editing.

Action Name:

queryForVariable

Non-Interactive Mode:

Not Supported

Permissions:

Accessible at Manager permission level

Context States and Icons

This context has no states. It is always represented by the icon.

Advanced Information

Context Information

Context Type: queries

Context Name: queries

Context Description: queries

Context Path: users.USER_NAME.queries

Context Mask: users.*.queries

Context Permissions

[?]

Level

Description

None

No access allowed.

Observer

Basic event monitoring.

Operator

Same as Observer.

Manager

Query creation, export and import.

Engineer

Same as Manager.

Administrator

Native query execution.

Public Variables (Properties)

[?]

This context has no public variables (properties).

Public Functions

[?]

Common Functions: makeCopy (Make Copy), delete (Delete)

Create

Creates new query.

Function Name:

create

Permissions:

Accessible at Manager permission level

Input Records:

1

Input Format:

Same as format of childInfo variable in Query context.

Output Records:

0

Output Format:

none

Public Events

[?]

Common Events: info (Information)

Was this page helpful?