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?

score 6 · Accepted Answer · answered May 13 '17 at 08:05

6

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:

Set value 'return' from LOV with affected item P1_ITEM.
Execute JavaScript code

$("#P1_ITEM").val(display)

answered May 13 '17 at 08:05

Paweł Prusinowski

416
3
6

2

And there still isn't a better way... I wonder when will they change that – Paulo Künzel May 08 '20 at 11:05

score 0 · Answer 2 · edited Jun 15 '20 at 08:43

0

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

where display is the name of the field in SQL.

Hope it works.

edited Jun 15 '20 at 08:43

Jaimil Patel

1,301
6
13

answered Jun 13 '20 at 02:22

user3692317

21
2

score 0 · Answer 3 · answered Apr 07 '23 at 16:50

0

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 ([])

answered Apr 07 '23 at 16:50

EJA

21
3

Set value of Popup LOV with dynamic action

3 Answers3