1 Reply Latest reply: May 16, 2017 6:01 AM by Vineeth Pujari RSS

    Question

    sanjay gupta

      I need your team help to implement the below oracle query in qlikview

       

      SELECT C.*
        from circuitcircuit cc
        start with EmpID in ( /*PASS EmpID WHOS HIERARCHY NEEDS TO BE FETCHED*/)
        connect by prior EmpID=MgrID

       

      Above query provide the highest level of hierarchy followed by lowest level

       

      For example :-

       

      EmpID

      MgrID

      1

      0

      2

      1

      3

      2

      4

      3


        

      If I select EmpID 3 then it should give me three records   

       

      EmpID

      MgrID

      1

      0

      2

      1

      3

      2

         

      For any doubt please let me know