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.
...
Ignore Values
Enter value(s) to ignore for in select query response.
...
Blocks
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.
...
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> |