Forum Stats

  • 3,767,858 Users
  • 2,252,726 Discussions
  • 7,874,367 Comments

Discussions

APEX 20.1 Change Popup LOV based on Page Item

hiddenonearth
hiddenonearth Member Posts: 91 Red Ribbon

Hello,

i need a workaround where the List of Values change dynamically of the Popup LOV based on a Page Item. For instance when the Page Item holds the value 1 then the values of the POPUP LOV should be 10, 11, 12, 13 and so on. When the Page Item holds the value 2 then it should be 20, 21, 22 and so on. I need this not for numbers but for the different departments with its divisions.

Any help is appreciated.

Thank you.

Answers

  • PMON
    PMON Member Posts: 1,260 Gold Trophy

    In your popup LOV SQL you can reference the value of your page item using bind syntax

    select 1 
    from dual 
    where :P1_ITEM ='Y'
    

    Then in your Popup LOV under Cascading List of Values set Parent Item(s) = P1_ITEM, Items to Submit = P1_ITEM, Parent Required = On

    That should give you what you want.

    Cheers