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?

Blackness

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)

Quassia

And there still isn't a better way... I wonder when will they change that – Holophrastic

Answer 2

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

where display is the name of the field in SQL.

Hope it works.

Lydialydian

Answer 3

This honestly worked the best for me. And was so simple! All you need to do is apex.item('P1_PAGE_ITEM').getValue([1])

It's as simple as using apex.item getValue and rather than () you need to use ([])

Vasomotor