Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 15 Next »

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.

Parameters

Target schema, table and to include all fields option is presented at this section.

Target Schema
Select one of the newly created or imported database schemas from this dropdown menu.

Target Table
After selecting the target schema, select a newly created or imported database table from dropdown menu.

Include All Fields?

  • Yes, include all fields always. : Check this option if you want to include all fields in the query result.

Fields

Select the fields you want to include in the query result. You can specify field order using arrow buttons on the right side.

Field
Lists columns of selected database and its related tables.

Caption
Caption to display to user. If not specified field is hidden to user.

Formula
The formula to use for aggregate values.

Mapped XPath
XPath to map field value on data model. If not specified Name property is used.

Order

Field
Specify field(s) to regard when ordering.

Order Type
Select ordering type.

  • Ascending
  • Descending

Criteria

Add as many criteria as you want to create you where clause.

Field
Specify field(s) to filter select query.

Formula
The formula to use for aggregate values.

  • Count
  • Sum
  • Average
  • Minimum
  • Maksimum
  • Average of distinct values
  • Sum of distinct values
  • Count of distinct values

Comparison
Criteria value comparison.

  • Equals
  • Different
  • Like
  • Less than
  • Greater than
  • Less than or equals
  • Greater than or equals

Value
The criteria value. You may use expression { and } identifiers when needed.

Condition
Condition to merge with next criteria.

  • And
  • Or

Ignore Values
Enter value(s) to ignore in select query.

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.

Sub Queries

Creates a sub query in your select query.

Relation
Lists relations of the specified table from main query.

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.

Data

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".

<Folders>
    <Folder>
		<Name>folder1</Name>
	</Folder>
    <Folder>
		<Name>folder2</Name>
		<Folders>
        	<Folder>
				<Name>folder2a</Name>
			</Folder>
        	<Folder>
				<Name>folder2b</Name>
			</Folder>
    	</Folders>
	</Folder>
</Folders>
  • No labels