Siebel Business Process Framework: Workflow Guide > Example Workflow Processes > Defining a Workflow Process That Traverses a Record Set to Close Service Requests >
Configuring the Query Steps
This task is a step in Defining a Workflow Process That Traverses a Record Set to Close Service Requests. In this topic you configure the Query Primary and Query Child steps. To configure the query steps
- Click the Query Primary workflow step, and then use the Properties window to define values described in the following table.
Property |
Value |
Business Component |
Service Request |
Operation |
Query |
- Click the Query Child workflow step.
- Use the Properties window to define values described in the following table.
Property |
Value |
Business Component |
Service Request No Link |
Operation |
Query |
- Make sure the Query Child workflow step is still chosen in the Process Designer.
- Click the MVPW, and then click the Search Spec Input Arguments tab. Add a new record using values from the following table.
Field |
Value |
Expression Business Component |
Service Request No Link |
Filter Business Component |
Service Request No Link |
Search Specification |
"([Created] < Timestamp()-365.0) AND ([Description] = 'Test SR') AND ([Status] <> 'Closed') AND ([Status] <> 'Cancelled')" |
Enter the argument for the Search Specification exactly as described in the table. You must enclose the entire search specification in double quotes. You must use single quotes to enclose each search string. You must include a space before and after each operator, such as the equal sign (=) and the not equal sign (<>).
- Click the Output Arguments tab. Add a new record using values from the following table.
Field |
Value |
Property Name |
NumAcceptedRecords |
Type |
Output Argument |
Output Argument: |
NumAffRows |
The Query operation uses NumAffRows to store the total number of rows that the query returns. This example stores the value in NumAffRows in the NumAcceptedRecords process property, which makes the value available later in the workflow process on the Yes connector. This configuration handles the situation where the query returns no records.
- Add a new output argument using values from the following table.
Argument |
Value |
Property Name |
noRecord |
Type |
Literal |
Value |
false |
If the query returns one or more records at run time, then the Yes decision condition uses the value in noRecord to determine if the current record is the last record in the record set. The Read Next Record step processes this record.
- Add a new output argument using values from the following table.
Argument |
Value |
Property Name |
vRowId |
Type |
Business Component |
Business Component Name |
Service Request No Link |
Business Component Field |
Id |
VRowId allows you to display the record number in the Watch window while the workflow processes each record in the record set. You can use it for debugging purposes. Traversing a record set does not require this variable.
|