Dyanmically Change VO query in OAF
We often come across the requirement where View object query needs to be changed Dynamically. In this article we will be briefing out prerequisites steps about how to change query of view object. 1. I'm going to create view Object XxTestVO with below query . SELECT 'term_id' NEW_ID, 'name' NEW_NAME FROM DUAL WHERE 1 = 2 ** Important Point : View object whose query needs to be changed dynamically must have same columns and Column names For example , i will be replacing vo query with below query based on certain condition. Select term_id New_id, Name NEW_NAME from ra_terms or Select customer_trx_id NEW_ID, customer_Trx_name NEW_NAME from ra_customer_trx_all 2. You can set query both in Process request and Process Form request method based on your requirement. public void processRequest(OAPageContext pageContext, OAWebBean webBean) { super.processRequest(pag...