Filtering af:table Without Using ADF Model

You might have seen filterable table demo in ADF Rich Client Demo App- http://jdevadf.oracle.com/adf-richclient-demo/faces/components/table/filterableTable.jspx . Today's my post is based on this item.If you want, you can download the demo source and run it locally by following the instructions given in this page http://www.oracle.com/technetwork/developer-tools/adf/documentation/adf-faces-rc-demo-083799.html

In this post I'm sharing an example illustrating table filtering with hand made FilterableQueryDescriptor. This example reuses the same implementation from rich client demo for building the custom FilterableQueryDescriptor. The TableFilterBean::processTableFilter()  method has the logic for extracting the filter criteria passed by the client. Logic for filtering the actual collection is not added - it's not there in ADF Rich Client Demo as well ;-)

Download

You can download the sample workspace from here.
Check out TableFilterBean class - You may see more code here than you expected :-)
 [Runs with Oracle JDeveloper 11g R1 11.1.1.6.0]

Comments

Anonymous said…
Sir, I just downloaded the project and run the page. But the filters are not reflecting, ppr on page is fine I have checked that.

Can you say me what do I get when I print the sqlString and the end of processTableFilter method and what do I get when I print the sqlItem in each for loop.

Thanks in advance.

Disclaimer

The views expressed on this blog are my own and do not necessarily reflect the views of my employer.