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

1. 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

2. Click the Query Child workflow step.
3. Use the Properties window to define values described in the following table.

   Property	Value
   Business Component	Service Request No Link
   Operation	Query

4. Make sure the Query Child workflow step is still chosen in the Process Designer.
5. 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 (<>).

6. 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.

7. 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.

8. 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.