Query control is a combined control for querying several data sources. It performs relational database queries on domain SQL database, XML database queries XML databases 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
Specifies the xpath of target container node and its items to import the query results. For example UserList/User as UserList is the container and User is the recurring item.
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.