Wednesday, March 14, 2012

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]

1 comment:

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.