SubQuery¶

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

Capabilities¶

Definition¶

• SubQuery.Columns: An array of columns to include in the result set.
• SubQuery.TargetTable: The name of the table to execute the query against.

Properties¶

• SubQuery.MaxLength: The maximum number of rows to return. If not set, all rows are returned.
• SubQuery.Name: The name of the sub-query. The relation name can be used as the name.
• SubQuery.Order: An array of order expressions to sort the results.
• SubQuery.Parameters: Additional parameters to pass to the query.
• SubQuery.Relation: The name of the relation to use for the sub-query.
• SubQuery.Start: The starting index for the rows to return.
• SubQuery.TargetSchema: The name of the schema to execute the query against.
• SubQuery.Where: The criteria to filter the query results.
• SubQuery.XPath: The XPath expression to export the data to.

Parameters¶

• SubQuery.SubQueries: An array of sub-queries to include in the result set.