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.
Parameters
Will be updatedTarget 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 listed in from this dropdown menu.
Target Table
Will be updated. After selecting the target schema, select a newly created or imported database table from dropdown menu.
Include All Fields?
- Yes, include all fields always.
Fields
Will be updated.
...
Caption
Will be updated.
Formula
Will be updated.
...
- . : 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. 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.
Order
Field
Will be updated.
...
Will be updated.
Data
Will be updated.
Row Id XPath
Will be updated.
Hierarchy Column
Will be updated.
Hierarchy XPath
Will be updated.