6 Replies Latest reply: Apr 21, 2013 4:55 PM by Eve RSS

    Tree Region Example


      I'm using my apex.oracle.com 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"