This discussion is archived
2 Replies Latest reply: Oct 3, 2008 4:11 AM by SteveMuench RSS

Cascading LOV

597691 Newbie
Currently Being Moderated
Hi,

I need to implement Cascading LOVs.
There will be 4 LOVs

Display:

DisplayName FilterBy
company none
country company

department company
employee company, country, department

User then can perform some actions after selecting from these LOVs.
Mandatory parameters : Company, Country
Optional parameters : Department, Employee

I created four view objects for LOV: CompanyLOV, CountryLOV, DepartmentLOV, EmployeeLOV

In CountryLOV (values depends on 'company')
I created a bind variable called Bind_Company
I created View Criteria COMPANY_ID = :Bind_Company

In DepartmentLOV (values depends on 'company')
I created a bind variable called Bind_Company
I created View Criteria COMPANY_ID = :Bind_Company

In EmployeeLOV (values depends on 'company', 'country', department' )
I created three bind variables called Bind_Company, Bind_Country, Bind_DepartmentI created three View Criterias
1. FilterByCompanyViewCriteria: COMPANY_ID = :Bind_Company
2. FilterByCountryViewCriteria: COUNTRY_ID = :Bind_Country
3. FilterByDepartmentViewCriteria: DEPARTMENT_ID = :Bind_Department

I then created a DisplayVO.
1. It has transient attributes 'company','country','department','employee'
2. CompanyLOV, CountryLOV, DepartmentLOV, EmployeeLOV
are added as View Accessors to this VO.
The View Criterias are chosen and appropriate parameters are passed to the View Criterias
3. For each 'company','country','department','employee'
attribute, LOV is enabled and CompanyLOV, CountryLOV, DepartmentLOV, EmployeeLOV
are assigned appropriately.

However, when I run DisplayVO, nothing is displayed.

Any pointers are appreciated.

Thank you




Thank you for your time

Edited by: user594688 on Sep 17, 2008 7:54 PM

Edited by: user594688 on Sep 17, 2008 8:09 PM
  • 1. Re: Cascading LOV
    John Stegeman Oracle ACE
    Currently Being Moderated
    User,

    What technology are you using for your UI?

    If OA Framework - try their forum.

    If JSF/ADF Faces, have a search on this forum (or the standard JDeveloper forum) for "dependent listbox" "dependent drop-down" or similar topics to find out the solution (this is quite likely the single most asked question on this forum).

    If something else, please share.

    john
  • 2. Re: Cascading LOV
    SteveMuench Employee ACE
    Currently Being Moderated
    See this Oracle Magazine article for a how-to:

    [Defining Cascading List of Values | http://www.oracle.com/technology/oramag/oracle/07-sep/o57frame.html ]

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points