{"id":10630,"date":"2020-11-19T03:54:42","date_gmt":"2020-11-19T09:54:42","guid":{"rendered":"https:\/\/traust.com\/?p=10630"},"modified":"2022-10-24T16:09:11","modified_gmt":"2022-10-24T21:09:11","slug":"cascading-lov-with-a-popup-in-oracle-apex","status":"publish","type":"post","link":"https:\/\/traust.com\/blog\/cascading-lov-with-a-popup-in-oracle-apex\/","title":{"rendered":"Cascading LOV with a Popup in Oracle APEX"},"content":{"rendered":"

This blog will teach you how to create a cascading list of values (LOV) using Shared Components of Oracle APEX<\/a>.\u00a0After that, we will show you how to implement the cascading LOV with a popup LOV page item.<\/p>\n

Example Scenario<\/h2>\n

Imagine we are trying to build a form for a car repair shop.\u00a0The form we want to create will have two popup LOVs, one for the car make, and another for the car model.<\/p>\n

In this case we want to use two popup LOVs and not two select lists, because the lists of car makes and models would be too big.<\/p>\n

LOV Setup<\/h2>\n
    \n
  1. Navigate to Shared Components\/List of Values<\/li>\n
  2. Create two new dynamic LOVs<\/li>\n
  3. For this example, I am using two Function Returning SQL statements<\/li>\n<\/ol>\n

    \"\"<\/p>\n

    \"\"<\/p>\n

    return lov_car_model(v('P' || :APP_PAGE_ID || '_CAR_MAKE'));<\/code>
    \nIf we use this code, then the variable passed is not page specific.\u00a0This is useful when you have multiple pages that are reusing the same LOVs and page items.<\/p>\n

    Applying the First LOV to the Parent Page Item<\/h2>\n
      \n
    1. Select the page item you want to use as the parent LOV<\/li>\n
    2. Make the item a Popup LOV type<\/li>\n
    3. The parent LOV is straightforward and just needs to have the LOV assigned under the List of Values section<\/li>\n<\/ol>\n

      Applying the Second LOV to the Child Page Item<\/h2>\n
        \n
      1. Select the page item you want to use as the child LOV<\/li>\n
      2. Make the item a Popup LOV type
        \n\"\"<\/li>\n
      3. The child must have Manual Entry turned on if you are doing any set value Dynamic Actions for these two page items
        \n\"\"<\/li>\n
      4. In the List of Values section, in addition to selecting the child LOV, we need identify the parent item under Cascading List of Values<\/li>\n<\/ol>\n

        Requirements<\/h3>\n