1 Reply Latest reply on Jan 26, 2013 4:50 AM by Gor_Mahia

    tree link not working

      Can some pls take a look at my tree query below iam able to get correct tree structure but the link to call the reportpage14 isnt working,
      i have the items :P2_EMPNO(hidden) and P14_SELECTED_NODE
      select case when connect_by_isleaf = 1 then 0
                  when level = 1             then 1
                  else                           -1
             end as status, 
             "ENAME" as title, 
             (case when level = 1 then '#IMAGE_PREFIX#Fndtre11.gif' 
                   when level = 2 then '#IMAGE_PREFIX#Fndtre12.gif'
                   else '#IMAGE_PREFIX#Fndtre13.gif' end) icon, 
             "EMPNO" as value, 
             null as tooltip,    'f?p=&APP_ID.:14:APP_SESSION::::P2_EMPNO,P14_SELECTED_NODE:'||empno||','||empno as link 
      from EMP
      start with "MGR" is null
      connect by prior "EMPNO" = "MGR"
      order siblings by "ENAME"
      apex 4.1.1/oracle11g