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!

I cannot expand/collapse a specific tree node in Apex

1213307Oct 18 2014 — edited Dec 23 2014

I'm using Apex 4.2.6 (with theme 26) and I build a tree region with this simple connect by query, as instructed by Apex documentation:

select case when connect_by_isleaf = 1 then 0

            when level = 1             then 1

            else                           -1

       end as status,

       level,

       "PREFERENCIA" as title,

       null as icon,

       "ID" as value,

       null as tooltip,

       'f?p=&APP_ID.:90006:'||:APP_SESSION||'::::P90006_ID:'||"ID" as link

from "#OWNER#"."PREF_CLIENTES"

start with "ID_PAI" is null

connect by prior "ID" = "ID_PAI"

order siblings by "PREFERENCIA"

But when the page is show in browser, the tree region does not display the little triangles that allow click to expand/contract a single tree node. This is how the tree is rendered by Apex:

15567965445_67f7ac9c0e.jpg

I only can expand or contract all tree nodes, because the individual triangles to expand/contract an specific node are not show. I want my tree to be like this:

15567967875_4169c9f93d.jpg

What I am doing wrong? How can I display those little black/white triangles to expand/contract a specific node on tree?

Thanks in advance!

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 20 2015
Added on Oct 18 2014
4 comments
2,017 views