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.
...
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 formulas are available.
Mapped XPath
XPath to map field value on data model. If not specified Name property is used.
...
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.
Data
Will be updated.
Row Id XPath
Will be updated.
Hierarchy Column
Will be updated.
Hierarchy XPath
Will be updated.