Hi experts,
This questions applies to all versions of Apex. This is the typical scenario when you have a LOV with a SQL that includes an “enabled_flag” or “effective_date_from/to” or similar, where you can disable a value of the LOV, if the end user asks for it:
SELECT department_name dis
,department_id ret
FROM hr_departments
WHERE enabled_flag = ‘Y’
ORDER BY 1;
As it is expected, when a value is disabled, the LOV won't show this option anymore, but if you open an old record that already had this value, APEX will show the internal id/code, creating an ugly effect.
(Hope that everybody knows what I'm talking about).
What is your preferred solution to show it nicer and more elegant than showing the id/code?
Thanks,
Jose.