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.
...
Include All Fields
Check this option if you want to include all fields in the query result.
Data - (will be udated as Results)
Configure the overall returning data.
Row Id XPath
Give a specific Id for each row by filling this box with an XPath.
Hierarchy Column
In case you have a hierarchy on a table determined by one of its column, use this section to specify parent column's name to display your data in a hierarchical way or leave it empty to display data as plain list.
Hierarchy XPath
In a nested xml node structure, for example if your XML looks like the example below, you may specify the starting node of the recurrence. In this example Hierarchy XPath is "Folders".
| Code Block | ||
|---|---|---|
| ||
<Folders>
<Folder>
<Name>folder1</Name>
</Folder>
<Folder>
<Name>folder2</Name>
<Folders>
<Folder>
<Name>folder2a</Name>
</Folder>
<Folder>
<Name>folder2b</Name>
</Folder>
</Folders>
</Folder>
</Folders> |
...
Hierarchy Column
In case you have a hierarchy on a table determined by one of its column, use this section to specify parent column's name to display your data in a hierarchical way or leave it empty to display data as plain list.