QueryWithMappings¶

Defines a query with mappings to an XML structure.

Capabilities¶

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

QueryWithMappings.Map: A custom mapper function to apply to each node in the result set.
QueryWithMappings.MaxLength: The maximum number of rows to return. If not set, all rows are returned.
QueryWithMappings.Node: The root node for the mapping. If not specified, the global $Xml instance is used.
QueryWithMappings.Order: An array of order expressions to sort the results.
QueryWithMappings.Parameters: Additional parameters to pass to the query.
QueryWithMappings.Start: The starting index for the rows to return.
QueryWithMappings.TargetSchema: The name of the schema to execute the query against.
QueryWithMappings.Where: The criteria to filter the query results.
QueryWithMappings.XPath: The root XPath expression to map the data to.

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