5 Replies Latest reply: Oct 4, 2011 10:18 AM by Victor Machuca RSS

    Problem with hierarchy and "Show as Tree View"

      Hello,

      there is an Employee table which contains a Employee-Manager(another employee) relation in the form of hierarchy. I would like to have it displayed as a tree, similar to this example from Reference Manual:

      error loading image

      In the script I put the following code:

       


      hierarchy(EMPLOYEE_ID, MANAGER_ID, NODENAME)
      LOAD "EMPLOYEE_ID",
      "FIRST_NAME" & ' ' & "LAST_NAME" & ' (' & EMPLOYEE_ID & ')' as NODENAME,
      EMAIL,
      "MANAGER_ID",
      SQL SELECT *
      FROM HR.EMPLOYEES;


      When the list box is created with the nodename field, and "Show as Tree View" is selected nothing happens on the display; it is plain listbox as everyone is used to.

      Could anyone help me to understand what I miss with the code above?

      Thank you,

      bartek