...
Warning | ||
---|---|---|
| ||
This feature is deprecated. Please use Query Control instead. |
Performs relational database queries on domain SQL database.
...
Rules
Section Name Include Page EMK:_Section NameEMK: _Section Name
Validation Group
Name of validation group rules before executing the query. When any rule is failed, an error is shown on the screen and the query is not executed.
...
Formula specifies the method of evaluation of row values. Formula enumeration can be one of following values;
Value | Description |
---|---|
None | No aggregation is applied. All values in rows. |
Count | Count of row values. |
CountDistinct | Count of distinct values in rows. |
Sum | Sum of row values. Valid for numeric type columns. |
SumDistinct | Sum of distinct values in rows. Valid for numeric type columns. |
Avg | Average of row values. Valid for numeric type columns. |
AvgDistinct | Average of distinct values in rows. Valid for numeric type columns. |
Min | Minimum value in rows. |
Max | Maximum value in row values. |
Comparison
Specifies the comparison method of criteria value.
Value | Description |
---|---|
Equals | All rows with same value. |
LessThan | All rows that less than criteria value. |
LessThanOrEqualTo | All rows that less or equals to criteria value. |
GreaterThan | All rows that greater than criteria value. |
GreaterThanOrEqualTo | All rows that greater or equals to criteria value. |
Different | All rows with different than criteria value. |
Like | All rows that likes to criteria value. Criteria value can be used with * (star character) Like *ABC, ABC*, *ABC* |
Column Name
Column names can be specified as directly column name or relation path. Relation paths can be specified as "Relation.Relation.Column" format.
...
For example, you can use the following values as column names for above relational database model.
Column Name | Description |
---|---|
Name | Name of customer |
Orders.Id | Id of order |
Orders.Product.Name | Name of ordered product |
Example Query
The following query returns all customer names and counts of orders by product name criteria. Each row also contains the list of related customer orders as child rows.
...