oracle-apexoracle-apex-5

Set value of Popup LOV with dynamic action


I try to set the value of a popup lov with a dynamic action "Set value" of type PL/SQL Function Body. This works with a select list, but not with a popup lov. How can this be done?


Solution

  • Let's assume your item is P1_ITEM and your LOV is

    select display, return from table;
    

    In standard Select List value is stored in #P1_ITEM.

    In Popup LOV value is stored in #P1_ITEM_HIDDENVALUE, but displayed in #P1_ITEM.

    So in dynamic action, you need to set two actions:

    1. Set value 'return' from LOV with affected item P1_ITEM.
    2. Execute JavaScript code
    $("#P1_ITEM").val(display)