2 Replies Latest reply on Nov 25, 2012 6:56 AM by Subramanian Meyyappan

    Duplicate nodes in Tree table for self referencing relationship

    944338
      Hi,

      Consider the standard EMP table in scott schema. I need to get EMPLOYEE - MANAGER Hierarchical relationship. But its showing me duplicate nodes as well.

      [ADF Tree output|http://s11.postimage.org/4cg7taysz/Mgr_Emp_Tree.png]

      I want to show Tree starting with "7839 King" only. I have used a self-referencing link for the same but no luck.

      How can I achieve that.

      Thanks,
      Manu

      Edited by: Manu Batham on Oct 23, 2012 8:12 AM