How to Use Where Clause Pragmatically in OAF

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