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 comes into display. Visibility of control can be controlled by Rules or Section Name properties. When Filter content is not visible when this attribute is set to True value, Filter content is not visible.
Show Filter
Check to display the filter on the form.
Auto Select All
Specifies the query result picker is must be shown. Result 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 NameInclude Page _Section Name _Section Name
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
| Include Page | ||||
|---|---|---|---|---|
|
Data
Bound XPathInclude Page _Bound Xpath _Bound Xpath
Target XPath
Specifies Xpath of the xpath of target container node and its specific items to import the query results. Specified xpath is relative to parent of current node not XPath attributeFor 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. Following 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 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.
...