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 display inactive person's name but do not enable them in the select list

Jian-cdoNov 8 2019

Hello,

I have a list of value that looks like this:

select LOGIN as display_name, APEX_USER_ID as return_value

from TBL_APEX_USER

where enable=1

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.

Thanks.

Comments

Post Details

Added on Nov 8 2019
0 comments
338 views