0 Replies Latest reply on Nov 8, 2019 11:49 PM by Jian-cdo

    How to display inactive person's name but do not enable them in the select list




      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.