Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to refresh a Popup LOV based on a SQL Query?

lucile-aFeb 4 2020 — edited Feb 4 2020

Hello,

I created a Popup LOV item based on a SQL Query. When I click the button, I see the list of values - correct.

Let's say that there is a change in the database and my SQL Query returns now a different list of values. The issue is that if I click again on the LOV button, the list of values is still the previous one.

My question is: how to refresh the list each time I open the Popup LOV?

My current workaround is to have an additional button next to my Popup LOV item, with a DA "Click" that triggers a Refresh action of my Popup LOV...

My version of APEX is 19.2

Thanks for your help!

Comments
Post Details
Added on Feb 4 2020
16 comments
4,227 views