setwhereclauseparam in oaf

setwhereclauseparam in oaf

Setwhere clauseparam is the method in the OA framework to set the values of the VO parameters during run time. With the help of this method , we can create dynamic where clause of the view object. This method helps to pass the values to the VO parameters to create the dynamic output of the view object (VO). Setwhereclauseparam is used with the view object handle for which  we are passing  values of their view object. First we find the view object in the controller and then with the help of the View Object handle we set the where clause of the view object by sending values to its parameters. This is the Inbuilt function to set the dynamic where clauses in the VO.

 

OAApplicationModule am = pageContext.getApplicationModule(webBean);

ViewObject vo = am.findViewObject("XXINVVO1");

String inv=null;

if (vo!=null) {

              pageContext.writeDiagnostics(this, "succesfully set vo XXINVVO1 ", 3);

          }

          vo.setNamedWhereClauseParam("inv_id", inv);

          vo.executeQuery();

 

 

setwhereclauseparam in oaf