Query¶

Defines a query to retrieve data.

Capabilities¶

Definition¶

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

Properties¶

• Query.MaxLength: The maximum number of rows to return. If not set, all rows are returned.
• Query.Order: An array of order expressions to sort the results.
• Query.Parameters: Additional parameters to pass to the query.
• Query.Start: The starting index for the rows to return.
• Query.TargetSchema: The name of the schema to execute the query against.
• Query.Where: The criteria to filter the query results.
• Query.XPath: The XPath expression to export the data to.

Parameters¶

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