Table 21. Simple Look-Up Method Arguments
|
|
Context |
Optional. Property set of variables shared across all rows. |
Row Set |
The set of rows to process. |
Output Row Set |
Optional. The property set used for output. |
Process Condition |
A Boolean condition that is evaluated to determine whether to process each row. |
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} and {Row}. For example: [Price List Id] = {Row.Price List Id} AND [Product Id] = {Row.Product 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 = Y. |
Cache Search Specification |
Optional. Additional terms that define the key values for the Level 1 cache (example: [Price List Id] = {Row.Price List Id}). See About PSP Cache. |
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. Default = N. |
On First Match [1..20] |
Actions to perform on the first query result for each input row. |
On Match [1..20] |
Actions to perform on every query result for each input row. |
On Last Match [1..20] |
Actions to perform on the last query result for each input row. |
On No Match [1..20] |
Actions to perform if there are no query results for an input row. |