Apex - Lists - Hierarchy

Skip to Main Content

Search For

Path Sort	Path Text	Entry Text	Display Sequence	Level	Entry Target	Page Id
->00010	->Home	Home	10	1	#	-
->00010->00011	->Home->Ted Struik - Oracle	Ted Struik - Oracle	11	2	f?p=&APP_ID.:1:&SESSION.::&DEBUG.::::	1
->00010->00012	->Home->Search	Search	12	2	f?p=&APP_ID.:2:&SESSION.::&DEBUG.:RP,RIR,CIR:::	2
->00010->00013	->Home->Site Map	Site Map	13	2	f?p=&APP_ID.:3:&SESSION.::&DEBUG.::::	3
->00010->00014	->Home->Statistics	Statistics	14	2	f?p=&APP_ID.:1113:&SESSION.::&DEBUG.::::	1113
->00010->00015	->Home->Page Errors	Page Errors	15	2	f?p=&APP_ID.:4:&SESSION.::&DEBUG.::::	4
->01000	->Apex	Apex	1000	1	#	-
->01000->01050	->Apex->General	General	1050	2	#	-
->01000->01050->01051	->Apex->General->Autocomplete	Autocomplete	1051	3	f?p=&APP_ID.:1011:&SESSION.::&DEBUG.::::	1011
->01000->01050->01052	->Apex->General->Conditions	Conditions	1052	3	f?p=&APP_ID.:1008:&SESSION.::&DEBUG.::::	1008
->01000->01050->01053	->Apex->General->Errors	Errors	1053	3	f?p=&APP_ID.:1012:&SESSION.::&DEBUG.::::	1012
->01000->01050->01054	->Apex->General->Items used in PL/SQL	Items used in PL/SQL	1054	3	f?p=&APP_ID.:1013:&SESSION.::&DEBUG.::::	1013
->01000->01050->01055	->Apex->General->Validations	Validations	1055	3	f?p=&APP_ID.:1019:&SESSION.::&DEBUG.::::	1019
->01000->01050->01057	->Apex->General->Dynamic Actions	Dynamic Actions	1057	3	f?p=&APP_ID.:1030:&SESSION.::&DEBUG.::::	1030
->01000->01050->01058	->Apex->General->Logs	Logs	1058	3	f?p=&APP_ID.:1031:&SESSION.::&DEBUG.::::	1031

1 - 15 of 189

Query to get a sorted list of the complete (root to child) path of an Apex list.

Page

Name
	Page ID	1021
	Name	Apex - Lists - Hierarchy

Region

Identification
	Sequence	10
	Title	Hierarchy
	Type	Interactive Report
Source
	Source Type	DYNAMIC_QUERY
	Region Source	select sys_connect_by_path(to_char(a.display_sequence,'fm00000'), '->') as path_sort , sys_connect_by_path(a.entry_text, '->') as path_text , a.entry_text , level , to_number( regexp_substr(a.entry_target, '[^:]+', 1, 2) ) as page_id , a.entry_target , a.display_sequence from apex_application_list_entries a where a.application_id = nvl(v('APP_ID'), 25384) and a.list_name = 'Navigation Menu' start with a.list_entry_parent_id is null connect by prior a.list_entry_id = a.list_entry_parent_id order by path_sort