APEX Instant Tips #35: Static LOVs in the Card Region
When working in a multi-lingual app, Static Lists of Values can be translated, and then used in classic reports, interactive reports and grids.
But what about the awesome card region?
In this episode, Anton shares a query he wrote to leverage an APEX view to be able to leverage translations of static LOVs in the APEX Card Region.
Here are the details of the view:
CREATE OR REPLACE FORCE VIEW "AIT_APP_LOV_ENTRIES_XLATED_V" as
select *
from apex_application_lov_entries alov
where sys_context('APEX$SESSION','APP_ID') is null -- show everything when not in an application
or (alov.primary_application_id = sys_context('APEX$SESSION','APP_ID')
and alov.translated_app_language = (select nvl(apex_util.get_session_lang, 'en') the_language from dual)
)
/