Hi Friends, today I'm going to tell you how to make a dependent LOV(list of values).
tested on oracle Jdeveloper 11.1.1.7
1. Create a
Fusion-Web-Application. name it anything I named id as
Dependent_LOV.
2. Select Next and click Finish.
3. Select new from model and goto to business tier, adf business component and Select business component from tables.
4. create your connection.
5. I've created two new tables named
continent and
country in the
hr schema.
continent sql country sql
6. Make a bind variable name it
CurrentContinent in
CountryVO. in
query section.
7. edit the SQL QUERY
8. copy and paste the query in the where clause.
CountryEO.CONTINENTS=:CurrentContinent
9. make a LOV. from the CountryVO
First Continent LOV
10.from the data list source select a create a new view accessor
11. shuttle the ContinentVO1 to the right hand side. and select ok.
12.select list attribute as id. and in the ui-hints shuttle the ContinentName
13. Now the MOST important LOV i.e. the country LOV
create the new view accessor from the data source. and select the CountryVO1 and EDIT it
14 in the edit view accessor. see the bind parameter values and write that component of the current VO on which our current LOV is showing dependency i.e. in our case the Continents
apply it and OK.
15. list attribute:- id, ui hints display attributes CountryName. and avoid selecting no included item.
16. save It and run the app module.
it will ask for the bind varaible,just click okay.
and Open CountryVO.
thank you :)