I want to show different list in navigation menu bar in different page in oracle apex. How can I override Navigation Menu Bar?
0
votes
2 Answers
1
votes
- go to navigation menu list entry
- go to "Conditions" section and create a condition
set its type to e.g. "PL/SQL Function Body returning a Boolean"
enter code which will use
:APP_PAGE_IDas it lets you know which page you're currently on, and lets you decide whether to display that menu entry for that page or not. For example, to display it when you're on pages 2, 4 and 9 enterreturn :APP_PAGE_ID in (2, 4, 9);
0
votes
Gazi Salahuddin
If I were you, I would use the Authorization Schemes on each item menu.
Basically, an authorization scheme is based on roles and it will show the corresponding menu items to the corresponding users but depends on the role or roles.
For example: Exists SQL Query
select count(*) from users where user = 'username' and role = 'Admin';
If the result of my dummy query returns data, the authorization scheme will render the component.
Tip: authorization schemes can be applied to anything in Oracle APEX.
Here is the link to the documentation.
