SubQueries¶
Array of sub queries.
1 | |
Types¶
SubQuery¶
Columns : Array<QueryColumn>
Array of columns
MaxLength : number
Maximum number of rows. If not set all rows are returns.
Name : string
Name of sub query. Relation name can be used as name.
Order : Array<QueryOrder>
Array of order columns
Parameters : object
Additional parameters
Relation : string
Name of relation
Start : number
Start index of rows.
SubQueries : Array<SubQuery>
Array of sub queries.
TargetSchema : string
Name of schema to execute query on.
TargetTable : string
Name of table to execute query on.
Where : QueryBlock
Criteria of query
XPath : string
Specifies the target xpath to export data on.
QueryColumn¶
Defines a query column to included in result
Expression : string
Expression of column.
Name : string
Name of column to use in results. If not specified expression is used.
XPath : string
XPath to be mapped.
QueryOrder¶
Defines order expression of query result
Expression : string
Expression to order.
Type : ( "Ascending" | "Descending" )
Type of ordering. If not specified Ascending is used.
QueryBlock¶
Blocks : Array<QueryBlock>
Array of criteria blocks
Condition : ( "And" | "Or" )
Condition with next block. If not specified And value is used.
Criteria : Array<QueryCriteria>
Array of criteria
QueryCriteria¶
Defines a criteria to be used to filter results
Comparison : ( "Equals" | "Different" | "LessThan" | "GreaterThan" | "LessThanOrEqualTo" | "GreaterThanOrEqualTo" | "Like" )
Comparison operator. Default value is Equals.
Condition : ( "And" | "Or" )
Condition with next criteria. If not specified And value is used.
Expression : string
Criteria expression.
IgnoredValues : any
Array of ignored values.
Value : any
Value or Expression to compare
ValueType : ( "Direct" | "Expression" )
Type of value. If not specified Direct value is used.