Using Parametrized WHERE Clauses

If you have some, but not complete, information about the WHERE clause you want for a view object definition, you can dynamically set individual WHERE clause parameters in particular view object instances at runtime.

To parametrize the WHERE clause in a view object definition:

Open the View Object Editor by doing one of the following:
- In the System or Application Navigator, right-click the view object definition and choose E dit.
- On a diagram of business components, double-click the modeled view object. For more information on modeling business components, see About Modeling Business Components.
Select the Query node.
In the Where field, enter a WHERE clause using parameters. Do not include the word "WHERE". Unless you are running against a non-Oracle database, we suggest you use Oracle-style parameters:
ORDER_TOTAL > :1 + :2

:1 is the first parameter, and :2 is the second parameter.

If you are running against a non-Oracle database, you will need to use ?-style parameters:

ORDER_TOTAL > ? + ?

In this case, the first ? is the first parameter, and the second ? is the second parameter.
If you have used ?-style parameters, ensure that Use ? Style Parameters is checked.

To specify parameter values for a particular view object instance at runtime:

For each parameter, create an Object (usually a String) containing the value of the parameters:
```
String firstParam = "500";



String secondParam = "1000";                
```
Do one of the following:
- To set individual parameters, pass the parameter index (starting with 0) and the parameter value into setWhereClauseParam() on the view object instnace:
  ordVO.setWhereClauseParam(0, firstParam);
- To set all parameters, pass an array containing the parameter values, in order, into setWhereClauseParams() on the view object instance:
```
ordVO.setWhereClauseParams(



  {



    firstParam,



    secondParam



  }



);                        
```