APEX

Bernhard Fischer-Wasels wrote:

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

The query contains no start with clause to specify the menu's root node(s), therefore multiple trees are constructed using each row as a root.

Add the start with clause:

...

start with gm_parent_gm_uid = 0