I'm fairly new to APEX, but finding my way around it reasonably well with help from older posts on this forum and others. I found a few descriptions for SQL based Navigation Menus. I created one in my app that would make navigation items based on the top X values. I also want some menu items available that are only accessible to administrators. I see that option when I build a List under the Authorization Scheme column.
I can add that item to my SQL like this:
select
'2' o1
, 'Add/ Edit Various' label
, 'f?p='||:APP_ID||':103:'||:APP_SESSION||'::'||:DEBUG||':::' target
, case
when '103' = :APP_PAGE_ID
then 'YES' else 'NO'
end as is_current
, 'fa-table' image
, null a1_desc
, null a2_info
, null a3_inits
, null a4_list_cls
, null a5_lnk_attr
, null a6_color
, null a7_sub_title
, 5 subsort
from dual
But that makes the item visible to non-admin users. How can I include the authorization attribute in the SQL statement? I saw a few places that there are 10 attributes, but I can't find the definition of those. When i look at the SQL of my APEX apps, I see this representing one of the static items I created as a Navigation Menu:
wwv_flow_imp_shared.create_list_item(
p_id=>wwv_flow_imp.id(14061715850063743)
,p_list_item_display_sequence=>2010
,p_list_item_link_text=>'Add/ Edit Various'
,p_list_item_link_target=>'f?p=&APP_ID.:103:&APP_SESSION.::&DEBUG.:::'
,p_list_item_icon=>'fa-table'
_**,p_security_scheme=>wwv_flow_imp.id(12674911379465020)**_
,p_list_item_current_type=>'COLON_DELIMITED_PAGE_LIST'
,p_list_item_current_for_pages=>'103'
I'm using APEX 22.2.4 within OCI. Thanks!