How to Use Where Clause Pragmatically in OAF

Use below code in VOImpl or Controller to add where condition to your View Object.

View Object Query:


 SELECT * FROM EMPLOYEE_TABLE;

Where clause usage:


     OAViewObject vo = (OAViewObject)am.findViewObject("XXEmpDetailsVO1");

     vo.setWhereClause(null);
    vo.setWhereClauseParams(null);
    vo.setWhereClause("Employee_Number = :1");
    vo.setWhereClauseParam(0,PersonID);
    vo.executeQuery();