How to call InitQuery in OAF Page
in Application Module Impl.java
public void initQuery(String ProjectNumber, String TaskNumber) {
System.out.println("Entered initQuery");
CRCPoetFinderVOImpl vo = (CRCPoetFinderVOImpl)getCRCPoetFinderVO1();
//vo.setWhereClause(null);
System.out.println("Value passed to ProjectNumber is "+ProjectNumber);
System.out.println("Value passed to TaskNumber is "+TaskNumber);
//vo.setWhereClause("project_number = :1 and task_number = :2");
vo.setWhereClause(" project_number = "+"'"+ProjectNumber+"' and task_number = '"+TaskNumber+"'");
//vo.setWhereClauseParams(null);
//vo.setWhereClauseParam(0, ProjectNumber);
//vo.setWhereClauseParam(1, TaskNumber);
vo.executeQuery();
}
In CO
OAApplicationModule am = pageContext.getApplicationModule(webBean);
//ViewObject vo = am.findViewObject("CRCPoetFindVO1");
String ProjectNum = pageContext.getParameter("ProjectNumber") ;
String TaskNum = pageContext.getParameter("TaskNumber");
Serializable[] parameters = {ProjectNum, TaskNum};
System.out.println("AM Method is called");
am.invokeMethod("initQuery", parameters);
in Application Module Impl.java
public void initQuery(String ProjectNumber, String TaskNumber) {
System.out.println("Entered initQuery");
CRCPoetFinderVOImpl vo = (CRCPoetFinderVOImpl)getCRCPoetFinderVO1();
//vo.setWhereClause(null);
System.out.println("Value passed to ProjectNumber is "+ProjectNumber);
System.out.println("Value passed to TaskNumber is "+TaskNumber);
//vo.setWhereClause("project_number = :1 and task_number = :2");
vo.setWhereClause(" project_number = "+"'"+ProjectNumber+"' and task_number = '"+TaskNumber+"'");
//vo.setWhereClauseParams(null);
//vo.setWhereClauseParam(0, ProjectNumber);
//vo.setWhereClauseParam(1, TaskNumber);
vo.executeQuery();
}
In CO
OAApplicationModule am = pageContext.getApplicationModule(webBean);
//ViewObject vo = am.findViewObject("CRCPoetFindVO1");
String ProjectNum = pageContext.getParameter("ProjectNumber") ;
String TaskNum = pageContext.getParameter("TaskNumber");
Serializable[] parameters = {ProjectNum, TaskNum};
System.out.println("AM Method is called");
am.invokeMethod("initQuery", parameters);
No comments:
Post a Comment