About Query Method

Use this method to retrieve data from a Siebel business component into a BRP BusComp property. The query uses ForwardBackward cursor mode. For more information on cursor mode, see Siebel Object Interfaces Reference. The following table describes the input and output parameters for this method.

Parameter Name Direction Description

ActivateFieldName(1,2,3…n)

Input

The name of the fields that must be included in the query. List each field individually in a sequence.

Any field that you must use with the GetFieldValue and SetFieldValue methods, must be activated prior to using these.

There are no limits to the number of fields that can be activated, however, care must be taken since this affects performance of the query.

BusCompName

Input

The Name of the business component from which the data is to be retrieved.

SearchSpec

Input

The search specification applied to the business component when retrieving data. This is a regular Siebel Query Language expression.

Since the business service operates without a context of business object, the search spec must include the appropriate user keys when the query is used for an update.

SearchSpecFieldName(1,2,3…n)

Input

Search Spec Field Name/Value pair is an alternative way to set search spec on a field.

For example, SearchSpecFieldName1=Application Flag, SearchSpecFieldValue1=Y, then this is the equivalent of setting SearchSpec to be:

[Application Flag] = Y

SearchSpecFieldValue(1,2,3…n)

Input

SortSpec

Input

The sort specification applied to the business component when querying data.

Status

Output

The status of the query operation. Status can have one of two values:

  • Succeeded. Indicates that the query returned at-least one business component record.

  • Failed. Indicates that either the query returned no business component records or the query failed due to a system error.

Following any data operation, use the Status field to check for error conditions and take appropriate actions. See Handling Business Rules Processor Errors for information on error handling.

The following figure shows the use of Query method to retrieve data from the FINS Health Provider business component.

This figure shows the Business Service Step dialog. There are a list of arguments listed that are used to query data from the FINS Health Provider business component.