Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

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
languagexml
<Folders>
    <Folder>
		<Name>folder1</Name>
	</Folder>
    <Folder>
		<Name>folder2</Name>
		<Folders>
        	<Folder>
				<Name>folder2a</Name>
			</Folder>
        	<Folder>
				<Name>folder2b</Name>
			</Folder>
    	</Folders>
	</Folder>
</Folders>

Results

Options to map and format the result data.

Item XPath
Specifies item that will be listed in dropbox. If it is left empty, which is same with * value, all resulting items are being listed.

List Item Formatting

Customizes format of query result.

Display Text Format
Specify the format to display result text. You can use column names inside curly braces. Ex: {{Name}} - {{Id}}

Value Format
Specify the format of value. You can use column names inside curly braces. Ex:  {{Id}} - {{Type}}

Selection Mappings

In order to map any result data into an XPath, create a mapping by pressing Add New button.

Source  
Name of data to be mapped.

Target
XPath to map the data.

Hierarchy Column
d