Apex 5.1.4
I suppose this is aimed at the Dev team really.
Using a SQL statement to create the Navigation Bar entries - it puts all sub level entries underneath the last top level nav bar menu entry.
The following post had a response from Patrick Wolf stating a bug (#23560509) and proposal to fix in 5.1.x
Dynamic Navigation Menu works but Dynamic Navigation Bar does not
Just wondering if this was fixed in 5.1.0 and regressed in 5.1.4 (I don't have a 5.1.0 environment to try)
However: It is still "un-fixed" in 18.1
Example App: https://apex.oracle.com/pls/apex/f?p=58832
I'm not too worried as I have an alternate solution - but to all you clever chaps out there - is there a workaround?
Can I manipulate the SQL below to help the ordering in the navbar?
Example dynamic SQL as the Nav Bar list
SELECT 1
, 'Main 1' label
, NULL target
, NULL image
, NULL attribute1
, 'mainClass1' attribute2
FROM dual
UNION
SELECT 2
, 'Main 1- Sub 1' label
, 'javascript:alert(''Main 1 - Sub 1'');' target
, NULL image
, NULL attribute1
, 'main1SubClass' attribute2
FROM dual
UNION
SELECT 2
, 'Main 1 - Sub 2' label
, 'javascript:alert(''Main 1 - Sub 2'');' target
, NULL image
, NULL attribute1
, 'main1SubClass' attribute2
FROM dual
UNION
SELECT 1
, 'Main 2' label
, NULL target
, NULL image
, NULL attribute1
, 'mainClass2' attribute2
FROM dual
UNION
SELECT 2
, 'Main 2 - Sub 1' label
, 'javascript:alert(''Main 2 - Sub 1'');' target
, NULL image
, NULL attribute1
, 'main2SubClass' attribute2
FROM dual
UNION
SELECT 1
, 'Main 3' label
, NULL target
, NULL image
, NULL attribute1
, 'someClass' attribute2
FROM dual