How to execute vo in controller in OAF

How to execute VO in controller in OAF

We can execute the VO from the controller of the Page but we should have the control of the View object(VO) to which we want to execute. So, to do this we first get the control of the Application Module and then with the help of the application module we get the Control of the Desired VO which we want to execute. Usually, VO attach to the Oaf page automatically executes when that page load in the Application or when system event like PPR occurs but some time , we manually change the where condition of the view object dynamically during run time but to see the impact of the changed where clause we must need to execute this view object manually through controller in the OAF page, then after execute we can see the latest changes in the VO. Here below we will try to execute the View object from the controller

 

Here below is the code written in the Oaf page where we are setting the Parameters to the VO and then after that we are executing the VO to make the changes.

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();