Skip to content

Instantly share code, notes, and snippets.

@hhudson

hhudson/nav_search.sql

Last active July 28, 2023 16:02
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save hhudson/d2b5bdd496fe0ef563c142da07a0892b to your computer and use it in GitHub Desktop.
Save hhudson/d2b5bdd496fe0ef563c142da07a0892b to your computer and use it in GitHub Desktop.
Download ZIP
nav menu search for search configuration (AIT ep 117)
Raw
nav_search.sql
select aale.list_entry_id,
aale.entry_text,
aale.entry_target,
apex_plugin_util.replace_substitutions (
p_value => aale.entry_target) entry_url,
aale.entry_attribute_01,
aale.authorization_scheme,
aale.entry_image
from apex_application_list_entries aale
inner join apex_applications aa on aa.application_id = aale.application_id
and aa.navigation_list = aale.list_name
where aale.application_id = v('APP_ID')
and ait_menu_util.is_authorized_yn (p_authorization_name => aale.authorization_scheme ) = 'Y'
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment