Problem with selection from LoV oracle apex

156 Views Asked by At

I created a LoV for the a page item with following PL/SQL Code:

SELECT r.REASON AS displayed, r.CODE 
FROM REFUSAL_REASONS r
WHERE CODE='R';

I have set the following properties in the column mapping: Return Value:SHORTCODE, Display: DIISPLAYED, Default Sort: DISPLAYED

The problem is all reasons are displayed. However, no matter what I select, the same reason is always selected.

0

There are 0 best solutions below