DB 11.2 - APEX 5.1 - I have setup a Dynamic List used as a navigation menu (left side).
Those entries, which are assigned to a parent_id_page are shown below that parent entry - fine - as expected.
But the (sub-) entries are shown as entry on the same level as the parent entries as well.
Question: How can one avoid a.m. behaviour ?
Here are my entries:
Thanks in advance
Bernhard
-------------------------
My SQL Query reads:
Select
level as lvl
,GM_LABEL As label
,GM_TARGET As target
,GM_IS_CURRENT_LIST_ENTRY is_current_list_entry
,GM_IMAGE as imagevalue
,null image_attribute
,null image_alt_attribute
,null as attr1
From GM_GUI_MENU
--- my authorisation:
where ':'||GM_GUI_MENU.GM_MENU_MODULE||':' like
'%:'||(select M.ROLLE from AK_MITARBEITER M where upper(M.BENUTZERNAME) = upper(:APP_USER)||':%' )
Connect By Prior GM_UID = GM_PARENT_GM_UID
ORDER SIBLINGS BY GM_UID