SubQueries¶

An array of sub-queries to include in the result set.

1

 Array<SubQuery> myQuery.SubQueries

Types¶

SubQuery¶

Defines a sub-query to include within a main query.

Columns : Array<QueryColumn>
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<QueryOrder>
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 : Array<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 : QueryBlock
The criteria to filter the query results.

XPath : string
The XPath expression to export the data to.

QueryColumn¶

Defines a query column to be included in the result set.

Expression : string
An expression for the column, which can be a calculation or transformation.

Name : string
The name of the column to use in the results. If not specified, the

XPath : string
An XPath expression to map data to the column.

QueryOrder¶

Defines the ordering expression for the query results.

Expression : string
The expression to use for ordering the results.

Type : ( "Ascending" | "Descending" )
The type of ordering (ascending or descending). If not specified, defaults to "Ascending".

QueryBlock¶

Defines a block of criteria to group conditions within a query.

Blocks : Array<QueryBlock>
An array of nested query blocks.

Condition : ( "And" | "Or" )
The condition to combine this block with the next one. If not specified, defaults to "And".

Criteria : Array<QueryCriteria>
An array of criteria to apply within this block.

QueryCriteria¶

Defines a criteria to filter the query results.

Comparison : ( "Equals" | "Different" | "LessThan" | "GreaterThan" | "LessThanOrEqualTo" | "GreaterThanOrEqualTo" | "Like" )
The comparison operator to use. Defaults to "Equals".

Condition : ( "And" | "Or" )
The condition to combine this criteria with the next one. If not specified, defaults to "And".

Expression : string
An expression for the criteria.

IgnoredValues : any
An array of values to ignore.

Value : any
The value or expression to compare against.

ValueType : ( "Direct" | "Expression" )
The type of the