Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Tree region query - display APEX list as TREE QUERY

TomeoMay 9 2012 — edited May 24 2012
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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 21 2012
Added on May 9 2012
1 comment
674 views