This discussion is archived
6 Replies Latest reply: Apr 21, 2013 2:55 PM by Eve RSS

Tree Region Example

Eve Newbie
Currently Being Moderated

I'm using my workspace. I'm trying to create a tree region using the emp table. I'm using the typical wizard but when i run the page the tree is not displayed.

This is the query built by apex with the wizard.

select case when connect_by_isleaf = 1 then 0
when level = 1 then 1
else -1
end as status,
"ENAME" as title,
null as icon,
"EMPNO" as value,
null as tooltip,
null as link
from "#OWNER#"."EMP"
start with "MGR" is null
connect by prior "EMPNO" = "MGR"
order siblings by "ENAME"


  • Correct Answers - 10 points
  • Helpful Answers - 5 points