Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Navigation Bar and List Region output do not match

Scott WesleyAug 10 2016 — edited Aug 14 2016

I'm a big fan of using SQL to populate a List, which in turn represents a menu.

I'm having an issue where for a given List, the Navigation Bar output does not match a region using the same List.

navbar_menu.png

The green tick is where the List region using Navigation Bar template (Universal Theme) shows sub menu options that differ between sub menus, as expected.

The red tick shows the the right hand sub menu is just replicating the entries from "First sub". Second Sub does the same thing.

I've triple checked my data, and I'm sure the ordering is fine, as demonstrated by List region.

I checked out the template and thought maybe the Sublist Items portion of the template was missing a closing LI tag, but that didn't make a difference, and the List region honours it correctly.

I reversed the first expression in the order by and the replicated submenu options where 'Reporting, Another App, And another, Logout', not 'Sub 1, Sub 2'.

Would love some suggestions!

Sample

https://apex.oracle.com/pls/apex/f?p=9850:1

Workspace : swesley

User: otn

pwd: forum

List SQL

select lvl,label,target,is_current_list_entry,image,image_attribute,image_alt_attribute, attribute01, attribute02,attribute03

from menu_data

order by page_group_name, order_dropdown

Source data

create table menu_data (lvl number

,label varchar2(200)

,target varchar2(200)

,is_current_list_entry varchar2(200)

,image varchar2(200)

,image_attribute varchar2(200)

,imagE_alt_attribute varchar2(200)

,attribute01 varchar2(200)

,attribute02 varchar2(200)

,attribute03 varchar2(200)

,pagE_group_name varchar2(200)

,order_dropdown number);

Insert into MENU_DATA (LVL,LABEL,TARGET,IS_CURRENT_LIST_ENTRY,IMAGE,IMAGE_ATTRIBUTE,IMAGE_ALT_ATTRIBUTE,ATTRIBUTE01,ATTRIBUTE02,ATTRIBUTE03,PAGE_GROUP_NAME,ORDER_DROPDOWN) values (1,'Find','f?p=MYPAPP:FIND::::::',null,'fa-search',null,null,null,null,null,'a',1);

Insert into MENU_DATA (LVL,LABEL,TARGET,IS_CURRENT_LIST_ENTRY,IMAGE,IMAGE_ATTRIBUTE,IMAGE_ALT_ATTRIBUTE,ATTRIBUTE01,ATTRIBUTE02,ATTRIBUTE03,PAGE_GROUP_NAME,ORDER_DROPDOWN) values (1,'Base','f?p=MYAPP:BASE::::::',null,'fa-bullseye',null,null,null,null,null,'b',2);

Insert into MENU_DATA (LVL,LABEL,TARGET,IS_CURRENT_LIST_ENTRY,IMAGE,IMAGE_ATTRIBUTE,IMAGE_ALT_ATTRIBUTE,ATTRIBUTE01,ATTRIBUTE02,ATTRIBUTE03,PAGE_GROUP_NAME,ORDER_DROPDOWN) values (1,null,'f?p=201:DEBUG::',null,'fa-bug',null,null,null,null,null,'c',3);

Insert into MENU_DATA (LVL,LABEL,TARGET,IS_CURRENT_LIST_ENTRY,IMAGE,IMAGE_ATTRIBUTE,IMAGE_ALT_ATTRIBUTE,ATTRIBUTE01,ATTRIBUTE02,ATTRIBUTE03,PAGE_GROUP_NAME,ORDER_DROPDOWN) values (1,'First sub','f?p=SUB:HOME:::NO:::',null,null,null,null,null,null,null,'d102',0);

Insert into MENU_DATA (LVL,LABEL,TARGET,IS_CURRENT_LIST_ENTRY,IMAGE,IMAGE_ATTRIBUTE,IMAGE_ALT_ATTRIBUTE,ATTRIBUTE01,ATTRIBUTE02,ATTRIBUTE03,PAGE_GROUP_NAME,ORDER_DROPDOWN) values (2,'sub 1','#',null,'fa-hashtag',null,null,null,null,null,'d102',216856);

Insert into MENU_DATA (LVL,LABEL,TARGET,IS_CURRENT_LIST_ENTRY,IMAGE,IMAGE_ATTRIBUTE,IMAGE_ALT_ATTRIBUTE,ATTRIBUTE01,ATTRIBUTE02,ATTRIBUTE03,PAGE_GROUP_NAME,ORDER_DROPDOWN) values (2,'sub 2','#',null,'fa-hashtag',null,null,null,null,null,'d102',216857);

Insert into MENU_DATA (LVL,LABEL,TARGET,IS_CURRENT_LIST_ENTRY,IMAGE,IMAGE_ATTRIBUTE,IMAGE_ALT_ATTRIBUTE,ATTRIBUTE01,ATTRIBUTE02,ATTRIBUTE03,PAGE_GROUP_NAME,ORDER_DROPDOWN) values (1,'Second sub','f?p=SUB2:HOME:::NO:::',null,null,null,null,null,null,null,'d103',0);

Insert into MENU_DATA (LVL,LABEL,TARGET,IS_CURRENT_LIST_ENTRY,IMAGE,IMAGE_ATTRIBUTE,IMAGE_ALT_ATTRIBUTE,ATTRIBUTE01,ATTRIBUTE02,ATTRIBUTE03,PAGE_GROUP_NAME,ORDER_DROPDOWN) values (2,'sub a','#',null,'fa-user',null,null,null,null,null,'d103',223655);

Insert into MENU_DATA (LVL,LABEL,TARGET,IS_CURRENT_LIST_ENTRY,IMAGE,IMAGE_ATTRIBUTE,IMAGE_ALT_ATTRIBUTE,ATTRIBUTE01,ATTRIBUTE02,ATTRIBUTE03,PAGE_GROUP_NAME,ORDER_DROPDOWN) values (1,'App 1','f?p=APP1:HOME:::NO:::',null,null,null,null,null,null,null,'d105',0);

Insert into MENU_DATA (LVL,LABEL,TARGET,IS_CURRENT_LIST_ENTRY,IMAGE,IMAGE_ATTRIBUTE,IMAGE_ALT_ATTRIBUTE,ATTRIBUTE01,ATTRIBUTE02,ATTRIBUTE03,PAGE_GROUP_NAME,ORDER_DROPDOWN) values (1,'App 2','f?p=APP2:HOME:::NO:::',null,null,null,null,null,null,null,'d108',0);

Insert into MENU_DATA (LVL,LABEL,TARGET,IS_CURRENT_LIST_ENTRY,IMAGE,IMAGE_ATTRIBUTE,IMAGE_ALT_ATTRIBUTE,ATTRIBUTE01,ATTRIBUTE02,ATTRIBUTE03,PAGE_GROUP_NAME,ORDER_DROPDOWN) values (1,'App 3','f?p=APP3:HOME:::NO:::',null,null,null,null,null,null,null,'d204',0);

Insert into MENU_DATA (LVL,LABEL,TARGET,IS_CURRENT_LIST_ENTRY,IMAGE,IMAGE_ATTRIBUTE,IMAGE_ALT_ATTRIBUTE,ATTRIBUTE01,ATTRIBUTE02,ATTRIBUTE03,PAGE_GROUP_NAME,ORDER_DROPDOWN) values (1,null,'#',null,'a-Icon icon-user',null,null,null,'has-username',null,'z',-1);

Insert into MENU_DATA (LVL,LABEL,TARGET,IS_CURRENT_LIST_ENTRY,IMAGE,IMAGE_ATTRIBUTE,IMAGE_ALT_ATTRIBUTE,ATTRIBUTE01,ATTRIBUTE02,ATTRIBUTE03,PAGE_GROUP_NAME,ORDER_DROPDOWN) values (2,'Reporting','f?p=REPUT:HOME:::NO:::',null,null,null,null,null,null,null,'z',0);

Insert into MENU_DATA (LVL,LABEL,TARGET,IS_CURRENT_LIST_ENTRY,IMAGE,IMAGE_ATTRIBUTE,IMAGE_ALT_ATTRIBUTE,ATTRIBUTE01,ATTRIBUTE02,ATTRIBUTE03,PAGE_GROUP_NAME,ORDER_DROPDOWN) values (2,'Another app','f?p=ANOTHER:HOME:::NO:::',null,null,null,null,null,null,null,'z',0);

Insert into MENU_DATA (LVL,LABEL,TARGET,IS_CURRENT_LIST_ENTRY,IMAGE,IMAGE_ATTRIBUTE,IMAGE_ALT_ATTRIBUTE,ATTRIBUTE01,ATTRIBUTE02,ATTRIBUTE03,PAGE_GROUP_NAME,ORDER_DROPDOWN) values (2,'And another','f?p=AND:HOME:::NO:::',null,null,null,null,null,null,null,'z',0);

Insert into MENU_DATA (LVL,LABEL,TARGET,IS_CURRENT_LIST_ENTRY,IMAGE,IMAGE_ATTRIBUTE,IMAGE_ALT_ATTRIBUTE,ATTRIBUTE01,ATTRIBUTE02,ATTRIBUTE03,PAGE_GROUP_NAME,ORDER_DROPDOWN) values (2,'Logout',null,null,'fa-unlock-alt',null,null,null,null,null,'z',99999);

Cheers

This post has been answered by fac586 on Aug 10 2016
Jump to Answer

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Sep 11 2016
Added on Aug 10 2016
7 comments
1,217 views