Set value of Popup LOV with dynamic action

Question

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?

Answer 1

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)

Answer 2

$('#P1_ITEM').val(&display.)

where display is the name of the field in SQL.

Hope it works.