ADF Query with Parameters and List of Values
By Shay Shmeltzer-Oracle on Dec 03, 2009
This one is probably for ADF beginners, but it is a very common use case - so having a little demo can never hurt.
The goal is to enable the user to select a few values from drop down lists and based on these values filter the results of a query and display them in a table.
In our case we want to filter employees by the department they work in and the salary they have. And we want to show a list of departments that the user can choose from.
All you need to do is create an ADF BC view object with bind parameters, and then in your page drag the parameters one by one to the page to drop them as select lists.
See this demo: