ViewObjectImpl empVOImpl = getEmployeeView1(); ViewCriteria vc = empVOImpl.createViewCriteria(); ViewCriteriaRow vcr = vc.createViewCriteriaRow(); //criteria for employee id ViewCriteriaItem vci1 = vcr.ensureCriteriaItem("JobId"); vci1.setValue("SH_CLERK"); //criteria for showing employees whose salary are more than 10000 ViewCriteriaItem vci2 = vcr.ensureCriteriaItem("Salary"); vci2.setOperator(">"); vci2.setValue(new Number(10000)); //criteria for department int[] ids = {50,100}; ViewCriteriaItem vci3 = vcr.ensureCriteriaItem("DepartmentId"); vci3.setOperator("IN"); int i = 0; for(int deptId: ids){ vci3.setValue(i++, new Number(deptId)); } vc.addElement(vcr); empVOImpl.applyViewCriteria(vc); System.out.println("Query: " + empVOImpl.getQuery()); empVOImpl.executeQuery();
Thursday, 18 April 2013
How to define view criteria programmatically
The following code snippet will help you how to create a View Criteria programmatic:
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment