Grants Blog
News from the SOA, JEE, ADF, JDeveloper and Oracle Forms World

Last week I showed an example of a list of values being "filtered" depending on some defined attribute. In this example, you can see how the value selected in one list of values, influence the choices available in another list of values.

Here is a screenshot of what you are trying to achieve:

In this case, (a bug tracking application), the product combo box value will influence the choices available in the category field.

[More:]

This example uses JDeveloper 11 Technology Preview, and shows how you can put lists of values on the business services layer (Using ADF Business Components).

You basically follow the similar steps as outlined in my earlier article.

1) Create a VO CategoryCascading which defines the list of categories.
2) To make sure it only shows categories for a particular product id add a bind variable (CategoryBind)
3) Add a View Criteria that will filter the ProductID based on the value of the bind variable

4) In the ReportVO (which is displays the bug information) add a view accessor which passes ProductId
5) Add the list of values to the ProductID and the Category attributes

Now run!

Now, depending on what product you choose (in this case: database), you get a different list of categories for that product. Cascading lists and not a single line of code!