ADF-UI: Custom ADF table filter (query by example) using af:selectManyChoice

Today I will explain how you can add custom table filter using <af:selectManyChoice>. This type of filter has already been explained using <af:selectOneChoice> at Custom ADF Filter with drop down. This example will extend this blog post by allowing to select multiple items in the drop down filter.

Download Sample Applicaton : JDeveloper 11.1.1.4

1. Create Application and business components.

2. Setup application module instances.

3. Create a JSF page with table to display EmployeeVO data.

4. Add the following JavaScript to execute the filter query when the selection changes inside <af:selectManyChoice>.

NOTE: To enable AdfLogger in JavaScript, you need to add the following context-param in web.xml. You can read more about this at Oracle AdfLogger. The log will appear in browser console (F12 Developer Tools for ID, FireBug for Firefox)

     <context-param>
          <description>JavaScript Logging</description>
          <param-name>oracle.adf.view.rich.LOGGER_LEVEL</param-name>
          <param-value>OFF</param-value>
     </context-param>

5. Create iterator and tree binding for Job1 view object inside page definition.

 6. Add custom <af:selectManyChoice> inside "filter" facet of JobId column.

7. Add <af:clientListener> to invoke on "valueChange" event.

The "~" at the beginning and end of "#{row.JobId}" is there as delimiter in case if the JobId contains ",".

8. <af:selectManyChoice> will send the selected values as an array so you have to override the following method under EmployeeVOImpl to generate custom clause using "IN" operator.

Run the application:

Enjoy :)