SubQueries¶
An array of sub-queries to include in the result set.
1 | |
An expression for the column, which can be a calculation or transformation.
Name : ( ... | ... )
The name of the column to use in the results. If not specified, the
XPath : ( ... | ... )
An XPath expression to map data to the column.>
An array of columns to include in the result set.
MaxLength : number
The maximum number of rows to return. If not set, all rows are returned.
Name : string
The name of the sub-query. The relation name can be used as the name.
Order : Array<Expression : ...
The expression to use for ordering the results.
Type : ...
The type of ordering (ascending or descending). If not specified, defaults to "Ascending".>
An array of order expressions to sort the results.
Parameters : object
Additional parameters to pass to the query.
Relation : string
The name of the relation to use for the sub-query.
Start : number
The starting index for the rows to return.
SubQueries : SubQuery[]
An array of sub-queries to include in the result set.
TargetSchema : string
The name of the schema to execute the query against.
TargetTable : string
The name of the table to execute the query against.
Where : Blocks : ( ... | ... )
An array of nested query blocks.
Condition : ( ... | ... | ... )
The condition to combine this block with the next one. If not specified, defaults to "And".
Criteria : ( ... | ... )
An array of criteria to apply within this block.
The criteria to filter the query results.
XPath : string
The XPath expression to export the data to.> myQueryWithMappings.SubQueries