This control provides querying for relational databases. When this control is selected, there appears a menu 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 to include all fields option is presented at 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 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 order using arrow buttons on the right side.
Field
Lists columns of selected database and its related tables.
Caption
Caption to display to user. If not specified field is hidden to user.
Formula
The formula to use for aggregate values.
Mapped XPath
XPath to map field value on data model. If not specified 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}}. Expression should be an XPath, for example {{Search/Identity}}.
Condition
Condition to merge with next criteria.
- And
- Or
Ignore Values
Enter value(s) to ignore in select query.
Blocks
In order to isolate conditions properly you may use block structure for where clause. Add as many block 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 main query.
Mapped XPath
XPath to map field value on data model. If not specified 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 item that will be listed in the related control. If it is left empty, which is same with * value, all resulting items are being listed.
List Item Formatting
Customizes format of control's display options.
Display Text Format
Specify the format to display result text. You can use column names inside curly braces. Ex: {{Name}} - {{Id}}
Value Format
Specify the format of value. You can use column names inside curly braces. Ex: {{Id}} - {{Type}}
Selection Mappings
In order to map a column data from query result into an XPath, create a mapping by pressing Add New button.
Source
Name of data column to be mapped.
Target
XPath to map data. (Be sure to include the item xpath also. e.g. Activities/Activity)
Hierarchy Column