Thursday, January 19, 2012

ADF 11G : How to add the ViewCriteria Programatically

public String viewCriteria() {
// Add event code here...

System.out.println("viewCriteria()");
String amDef = "model.AppModule";
String config = "AppModuleLocal";

ApplicationModule am = Configuration.createRootApplicationModule(amDef, config); ViewObject empVO=am.findViewObject("EmpView1");
System.out.println("-1-");
ViewCriteria vc= empVO.createViewCriteria();
ViewCriteriaRow promotionRow = vc.createViewCriteriaRow();
System.out.println("-2-");
promotionRow.setAttribute("Age", ">= '"+11+"'");
System.out.println("-3-");
promotionRow.setAttribute("Salary", "> '"+1000+"'");
System.out.println("-4-");
vc.addElement(promotionRow);
System.out.println("-5-");
empVO.applyViewCriteria(vc);
System.out.println(empVO.getQuery());
System.out.println("-Executing Query-");
empVO.executeQuery();
return null;

}