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 come into display. Visibility of control can be controlled by Rules or Section Name properties. When this attribute set to True value, Filter content is not visible.
Show Filter
Check to display filter on the form.
Auto Select All
Specifies the query result picker is must be shown. 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
Validation Group
Name of validation group rules before executing query. When any rule is failed, error is shown on screen and query is not executed.
Dynamic Rules
Data
Bound 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 write UserList/User fo the target xpath.
Data Sources
In this section you can add any number of data sources to populate the related content. 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.