Query Control

Query control is a combined control for querying several data sources. It performs relational database queries on domain SQL database, XML database queries and some others, which are explained below.

Design

Auto Search
Specifies the query control should perform search immediately when comes into display. Visibility of control can be controlled by Rules or Section Name properties. Filter content is not visible when this attribute is set to True value.

Show Filter
Check to display the filter on the form.

Auto Select All
Specifies the query result picker must be shown. The result picker allows to select individual rows to edit. If you work with too many rows, picker is better method for performance. When set to True, all matching rows are immediately imported.

Clear First
Specifies the before query results populated on data model all existing records are removed.

Rules

Section Name

The name of section is for controlling read only or visible state of a section. If set to a value, this section can be configured in task properties.

Validation Group
Name of validation group rules before executing the query. When any rule is failed, an error is shown on the screen and the query is not executed.

Dynamic Rules

The dynamic rules section allows specifying format and warning messages of any element and section. It consists of two parts, one of them is for formatting rules, and the other one is for validation rules.

Formatting rules allow you to change the formats (text colour, background colour, style) and visibility of control depending on a condition.
Further information can be found here.
Validation rules allow you to validate the data that the end user enters.
Further information can be found here.

Data

Bound XPath

XPath of the element. If set to empty, it uses the parent XPath.

Target XPath
Xpath of the target container node and its specific items to import the query results. For example, assume that you want to fill a UserList node containing multiple User child nodes. In this case, you need to use UserList/User as the target xpath.

Data Sources
In this section, you can add any number of data sources to populate the related content. The following source types are provided:

Static List Items: Lists the manually entered items.
Database Query: Lists the database query results.
XML Database Query: Lists the results of XML database results.
Form Data Query: Lists results of form data.
Web Service Query: Lists the result from web service query.
Content Types: List of available content types.
Security Profiles: List of available security profiles.