2 Replies Latest reply on Oct 3, 2008 11:11 AM by Steve Muench-Oracle

    Cascading LOV

    597691
      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
          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
            Steve Muench-Oracle
            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 ]