I have a list of value that looks like this:
select LOGIN as display_name, APEX_USER_ID as return_value
order by login
Then for one Select List item, I use this list of values as the source. The question is after a while, some user will be marked as disabled in the database. Then their name won't show in the Select List item, instead, the user ID is displayed. I wonder how I can still display the name of old users, but in the dropdown list, I don't want them to be listed. Say, for this Select list, it's used for both adding/updating new user and displaying existing value correctly.