Database Query¶
This control provides querying for relational databases. When this control is selected, there a menu appears on the right side of it with the Query designer. When selecting the Data tab, under the Data Sources, there is an "Add New" button. One of the options is Database Query.
Query¶
Parameters¶
Target schema, table, and include all fields option are presented in this section.
Target Schema Select one of the newly created or imported database schemas from this dropdown menu.
Target Table After selecting the target schema, select a newly created or imported database table from the dropdown menu.
Include All Fields?
- Yes, include all fields always. : Check this option if you want to include all fields in the query result.
Fields¶
Select the fields you want to include in the query result. You can specify field orders using the arrow buttons on the right side.
Field Lists columns of selected database and its related tables.
Caption The caption to be displayed to the user. If not specified, the field is hidden from the user.
Formula The formula to use for aggregate values.
Mapped XPath XPath to map field value on the data model. If not specified, the Name property is used.
Order¶
Field Specify field(s) to regard when ordering.
Order Type Select ordering type.
- Ascending
- Descending
Criteria¶
Add as many criteria as you want to create your where clause.
Field Specify field(s) to filter select query.
Formula The formula to use for aggregate values.
- Count
- Sum
- Average
- Minimum
- Maximum
- Average of distinct values
- Sum of distinct values
- Count of distinct values
Comparison Criteria value comparison.
- Equals
- Different
- Like
- Less than
- Greater than
- Less than or equals
- Greater than or equals
Value The criteria value. You should use an expression between these double brackets {{expression}}. The expression should be an XPath, for example {{Search/Identity}}.
Condition Condition to merge with next criteria.
- And
- Or
Ignore Values Enter a value(s) to ignore in the select query.
Blocks¶
In order to isolate conditions properly, you may use a block structure for the where clause. Add as many blocks as you want and select their condition.
Sub Queries¶
Creates a sub-query in your select query.
Relation Lists relations of the specified table from the main query.
Mapped XPath
XPath to map field value on the data model. If not specified, the Name property is used.
Include All Fields
Check this option if you want to include all fields in the query result.
Results¶
Options to map and format the result data.
Item XPath XPath of the item that will be listed in the related control. If it is left empty, which is the same as the * value, all resulting items are listed.
List Item Formatting¶
Customizes the format of the control's display options.
Display Text Format Specify the format to display the result text. You can use column names inside curly braces. Ex: {{Name}} - {{Id}}
Value Format Specify the format of the value. You can use column names inside curly braces. Ex: {{Id}} - {{Type}}
Selection Mappings¶
In order to map a column of data from the query result into an XPath, create a mapping by pressing Add New button.
Source Name of the data column to be mapped.
Target XPath to map data.
Hierarchy Column In case you have a hierarchy on a table determined by one of its columns, use this section to specify the parent column's name to display your data hierarchically or leave it empty to display data as a plain list.