Siebel Order Management Infrastructure Guide > Product Selection and Pricing Engine > Row Set Transformation Toolkit Methods >

Query Method


The Query method queries a business component and generates a row set. See Table 20 for further description.

Arguments
Table 20. Query Method Arguments
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 = 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}). See About PSP Cache.

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

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

Figure 29. Example of Arguments for Query Method
Click for full size image
Siebel Order Management Infrastructure Guide Copyright © 2008, Oracle and/or its affiliates. All rights reserved. Legal Notices.