Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Query Structure

<Query

Start="0"
Start index of results to fetch.

MaxLength="-1">
Maximum number of results to fetch.

<Parameters>
Query parameters.

<TargetSchema>MySchema</TargetSchema>
Name of schema of query target.

<TargetTable>MyTable</TargetTable>
Name of table of query target.

</Parameters>

<Columns>

...

List of columns to include in results.

<Column
 
Column definition. Any number of column can be specified.

Name=""
Name of column or relation path. Please see Column Name for more information.

Formula="None">

...

<Properties>

<XPath></XPath>

</Properties>

</Column>

<Column> ............ </Column>

<Column> ............ </Column>

</Columns>

...


Aggregation formula like count, max etc. Please see Aggregation for more information. 

<Properties>
Column specific properties. Currently  

<XPath></XPath>
XPath of column value mapping for rows. If not specified column name is used.

<Language></Language>
By default all columns are automatically localized by user language but with this property you can ask for explicitly specify the language. If language is not available, original column value is used.

</Properties>

</Column>

<Column></Column>

<Column></Column>

</Columns>

<Where

Condition="And">

<Criteria>

<Criteria

Name=""

Comparison=""

Condition=""

Formula="">

<Value></Value>

                        <Properties>

<IgnoreIfEquals><<IgnoreIfEquals>MyValue</IgnoreIfEquals>

                        </Properties>

...