Query Method

The Query method queries a business component and generates a row set.

Arguments

Input Argument	Description
Context	Optional. Property set of variables shared across all rows.
Output Row Set	The property set used for output.
Business Object	The business object to query.
Business Component	The business component to query.
Search Specification	A search expression comprised of business component fields, literals, and variable values from {Context}. For example: [Account Id] = {Context.Account Id}
In Memory Search Specification	Optional. Additional terms that are ANDed with the Search Specification. The In Memory Search Specification is executed in memory. This can be used only if Cache Enabled is Y.
Cache Search Specification	Optional. Additional terms that define the key values for the Level 1 cache; for example: [Price List Id] = {Row.Price List Id}) For more information, see Logging of Performance.
Process Condition	A Boolean condition that is evaluated to determine whether to process the query.
Sort Specification	Optional. A comma-separated list of business component fields used to sort the query result.
Cache Enabled	Optional. Specifies whether to cache query results. Y or N. the default is N.
On First Match [1..20]	Actions to perform on the first query result.
On Match [1..20]	Actions to perform on every query result.
On Last Match [1..20]	Actions to perform on the last query result.
On No Match [1..20]	Actions to perform if there are no query results.

Example

The following figure shows an example of arguments for a PSP procedure step named Get Account Address, which uses the Query method.