How to pass parameter to vo in OAF

How to pass parameter to VO in OAF

We pass parameters in VO to create the View Object where conditions dynamically during Run time. With the help of the Parameters we can change the data of the VO during runtime. VO will give dynamic output based on Parameters passes to the VO. Here below, We can see how we can pass parameters to the View Objects.

 

If you want to pass parameters in the VO then first, you need to create the Parameter in the VO sql Query and then we can pass the value to this Parameters from the OAF Page controller to change the Output of the view Object dynamically.

 

Here below, I am using the parameter in the VO sql query.

 

 

Before using the Parameters in the VO sql query , we first need to create the parameter in the bind Variables as below.

 

 

Here below is the code written in the Oaf page controller to pass parameter to vo in Oaf. I am using this Under Process Form Request.

OAApplicationModule am = pageContext.getApplicationModule(webBean);

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

String inv=null;

if (vo!=null) {

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

          }

          vo.setNamedWhereClauseParam("inv_id", inv);

          vo.executeQuery();