Creating view criteria programmatically

View criteria augment the view object's WHERE clause by appending additional query conditions to it. They work in conjunction with the af:query ADF Faces UI component to provide query-by-example support to the frontend user interface. View criteria can be created declaratively in JDeveloper in the Query section of the view object definition by clicking on the Create new view criteria button (the green plus sign icon) in the View Criteria section. Programmatically, the ADF-BC API supports the manipulation of view criteria among others via the ViewCriteria, ViewCriteriaRow, and ViewCriteriaItem classes, and through a number of methods implemented in the ViewObjectImpl class. This technique comes handy when the view criteria cannot be specified during the design stage. One example might be the creation of a custom query-by-example page for your application, in which case the view criteria must be created programmatically at runtime.

In this recipe...