Hi Folks,
I have defined a list in APEX, called 'Hlavní menu', application ID is 104.
I would like to display this list as tree, through query. When I run below query in SQL, or I put it into standard report, then displays data with no problems.
But, when I put this query into tree type of region, then nothing is being displayed.
select case when connect_by_isleaf = 1 then 0 when level = 1 then 1 else -1 end as status,
level,
le.entry_text as title,
NULL as icon,
le.entry_text as value,
NULL as tooltip,
NULL as link
--le.list_name, le.entry_text, le.parent_entry_text, le.display_sequence
from apex_application_lists l,
apex_application_list_entries le
where l.workspace = le.workspace
and l.application_id = le.application_id
and l.list_name = le.list_name
and l.application_id = 104
and l.list_name = 'Hlavní menu'
start with le.parent_entry_text is null
connect by prior le.entry_text = le.parent_entry_text
order siblings by le.display_sequence
Any idea what could be wrong?
Many thanks,
Tomas