This control provides querying for relational databases. When this control is selected, there appears an floating menu above or below it. Click Edit button from that menu to open the Query Designer.
...
Mapped XPath
XPath to map field value on data model. If not specified Name property is used.
Order
Field
Will be updatedSpecify field(s) to regard when ordering.
Order Type
Will be updated. Select ordering type.
- Ascending
- Descending
Criteria
Will be updatedAdd as many criteria as you want to create you where clause.
Field
Will be updatedSpecify field(s) to filter select query.
Formula
Will be updatedThe formula to use for aggregate values.
- Count
- Sum
- Average
- Minimum
- Maksimum
- Average of distinct values
- Sum of distinct values
- Count of distinct values
Comparison
Will be updatedCriteria value comparison.
- Equals
- Different
- Like
- Less than
- Greater than
- Less than or equals
- Greater than or equals
Value
Will be updatedThe criteria value. You may use expression { and } identifiers when needed.
Condition
Will be updatedCondition to merge with next criteria.
- And
- Or
Ignore Values
Will be updated. Enter value(s) to ignore for query response.
- Value,
Blocks
Will be updated.
Condition
Will be updated. 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
Will be updated.
Data
Will be updated.
Row Id XPath
Will be updated.
Hierarchy Column
Will be updated.
Hierarchy XPath
Will be updated.