Customized af:quickQuery component
Jdeveloper version – 11.1.2.2, Schema – HR The default support of af:quickQuery component is very rich. It would list all the selected searchable columns of the View Object in one selectOneChoice list and adjacent to it another selectOneChpice list displaying various operators and one input text box for input to be searched .Here the search gets restricted to one column. There would be use cases where the search is combination of multiple columns which can be supported by customizing this component. Fro the sake of an example take the following use case dependent on Employees table of HR schema - “Display the list of all the employees with first name is “David” and they had joined the organization with last 5 years.” In order to solve the above use case, in criteriaItems facet of quickQuery component add a selectOneChoice component and one inputTextbox component , see the code below - <f:facet name="criteriaItems"> <af:panelGroupLayout id=...