Page Comparison

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 updated.  Configure the overall returning data.

Row Id XPath
Will be updated.Give a specific Id for each row by filling this box with an XPath.

Hierarchy Column
Will be updated. Hierarchy XPath
Will be updated. 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".

<Folders>
    <Folder>
		<Name>folder1</Name>
	</Folder>
    <Folder>
		<Name>folder2</Name>
		<Folders>
        	<Folder>
				<Name>folder2a</Name>
			</Folder>
        	<Folder>
				<Name>folder2b</Name>
			</Folder>
    	</Folders>
	</Folder>
</Folders>