oracle-apexoracle-apex-22

Apex Oracle: multi-column popup lov

I have a multi-column popup LOV based on the query:

SELECT name d,
       id  r,
       code d2
FROM   employees
WHERE  codes IN ('ABC','DEF','GHI')
ORDER BY name

When retrieving its selected value, is it possible to grab both of the display values, d and d2?

Solution

  • If you want to get the name and code when you select from an LOV, the name you selected, where do you want to store it, in a text field?

    There is already a setting for this available here, under Additional Outputs: Additional Outputs

    In the image above, note the help message and the mapping I have. Here I am retrieving all values of the field and mapping them to page items. Here's the outcome:

    enter image description here