APEX 21.1 See https://apex.oracle.com/pls/apex/f?p=134181:72
The Popup LOV component uses a Shared Component SQL query with
select id,name,location,country from departments
The return value is ID, the display value is NAME
The settings are as follows
Questions
When I click on the button to popup the modal dialog, the LOV query is executed. Is this due to the Initial Fetch = Automatic and Minimum Characters = 0?
When I select a value, the dialog closes and the RETURN value is displayed in the field, NOT the DISPLAY value. Is this a bug?
In spite of Initial Fetch = Automatic with current value, the popup does not give any indication what the current selected value is
@patrick-wolf-oracle
Thanks