Set where clause dynamically in oaf

Set where clause dynamically in oaf

We use parameters to set the where clause dynamically in oaf. To set dynamic where clause first we create parametrized VO in OAF and then pass the parameters values from the controller to set its where clause dynamically. We set the where clause of the view object from the Page controller itself. We can also create the complete VO object dynamically from the Controller itself but that is something different topic but to create the dynamic where condition in the oaf you can refer this below code in your controller but before using this code , your VO should have parameters in the where clause so that it can accept the dynamic values from the controller for these parameters at runtime.

 

OAApplicationModule am = pageContext.getApplicationModule(webBean);

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

String inv=null;

if (vo!=null) {

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

          }

          vo.setNamedWhereClauseParam("inv_id", inv);

          vo.executeQuery();