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.
...
Order Type
Select ordering type.
- Ascending
- Descending
...
Criteria
Add as many criteria as you want to create you where clause.
...
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.
...
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> |
...