EJB Named
criteria are predefined and reusable where-clause definitions that are
dynamically applied
to a ViewObject query. Here we often use
to filter
the ViewObject SQL statement query based on Where Clause conditions.Take a scenario where we need
to filter the SQL statements query based on Where Clause conditions, instead of playing with SQL statements use the EJB Named Criteria which is supported by default in ADF and set the Bind Variable parameter at run time.You can download the sample workspace from here
[Runs with Oracle JDeveloper 11.1.2.0.0 (11g R2) + HR Schema] Implementation StepsCreate Java EE Web
Application with entity based on Employees table, then create a session
bean and data control for the session bean.Open the DataControls.dcx file and create sparse xml for as shown below.
In sparse xml navigate
to Named criteria tab -> Bind Variable section, create binding variable deptId.
Now create
a named criteria and map the query attributes
to the bind variable.
In the ViewController create index.jspx page, from data control palette
drop employeesFindAll->Named Criteria->EmployeesCriteria->Table as ADF Read-Only Filtered Table and create the backingBean as "IndexBean".Open
the index.jspx page and remove the "filterModel" binding from the
table, add <af:inputText />, command button and bind them
to
backingBean. For command button create the actionListener as
"applyEmpCriteria" and add below code
to the file.
public void applyEmpCriteria(ActionEvent actionEvent) {
DCIteratorBinding dc = (DCIteratorBinding)evaluteEL("#{bindings.employeesFindAllIterator}");
ViewObject vo = dc.getViewObject();
vo.applyViewCriteria(vo.getViewCriteriaManager().getViewCriteria("EmployeesCriteria"));
vo.ensureVariableManager().setVariableValue("deptId", this.getDeptId().getValue());
vo.executeQuery();
}
/**
* Programmtic evaluation of EL
*
* @param el EL
to evalaute
* @return Result of the evalutaion
*/
public
Object evaluteEL(String el) {
FacesContext fctx = FacesContext.getCurrentInstance();
ELContext elContext = fctx.getELContext();
Application app = fctx.getApplication();
ExpressionFactory expFactory = app.getExpressionFactory();
ValueExpression valExp = expFactory.createValueExpression(elContext, el,
Object.class);
return valExp.getValue(elContext);
}
Run the index.jspx page, enter departmentId value as 90 and click in
ApplyEmpCriteria button. Now the bind variable for the Named criteria
will be applied at runtime in the backing bean and it will re-execute
ViewObject query
to filter based on where clause condition.
