Performs relational database queries on domain database.
Xml Structure
<QueryContent AutoSearch="" ClearFirst="" ValidationGroup="" XPath="" SectionName="">
<Rules></Rules>
<TargetXPath></TargetXPath>
<ItemXPath></ItemXPath>
<RowIdXPath></RowIdXPath>
<HierarchyXPath></HierarchyXPath>
<HierarchyColumn></HierarchyColumn>
<Filter></Filter>
...
XPath
XPath of data model to bind control. If not set uses current node on data model.
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.
Section Name
Section name to control visibility of control.
Auto Search
Specifies the query control should perform search immediately when visible. Visibility of control can be controlled by Rules or Section Name properties. When this attribute set to True value Filter content is not visible.
Clear First
Specifies the before query results populated on data model all existing records are removed.
Target XPath
Specifies the xpath of target container node to import query results. Specified xpath is relative to parent of current node not XPath attribute.
For example, use "Filter" node for XPath attribute and use "Results" xpath for TargetXPath attribute.
| Code Block |
|---|
<Data>
<Filter>
<SearchField />
</Filter>
<Results>
<Row>
<Column />
</Row>
</Results>
</Data> |
Query Syntax
Relational database queries uses special markup to specify query to execute. Query structure is similar to SQL Select command but you may use sub queries and join clauses automatically handled.
Query Structure
<Query
Start="0"
Start index of results to fetch.
MaxLength="-1"
Maximum number of results to fetch.
>
<Parameters>
<TargetSchema></TargetSchema>
<TargetTable></TargetTable>
</Parameters>
<Columns>
<Column Name="" Formula="">
...
<XPath></XPath>
</Properties>
</Column>
<Column> ............ </Column>
<Column> ............ </Column>
</Columns>
<Where Condition="And">
...
<Value></Value>
</Criteria>
<Criteria> ............ </Criteria>
</
...
Criteria>
<Order/>
<SubQueries>
<Query Name<Blocks>
<Block Condition="
...
And">
<Criteria>
<Criteria> ............ </
...
Criteria>
</
...
Criteria>
</
...
Block>
<RowScript>
<Content><</Content>Blocks>
</RowScript>Where>
...
<Order/
...
>
Auto Search
Specifies the query control should perform search immediately when visible. Visibility of control can be controlled by Rules or Section Name properties. When this attribute set to True value Filter content is not visible.
Clear First
Specifies the before query results populated on data model all existing records are removed.
...
<SubQueries>
<Query Name="">
</Query>
</SubQueries>
</Query>
This control allows you to query your emakin based relational databases and map them with your form data.
...