Clarity

  • Private Community

  • 1.  SQL Query for all ChildTasks

    Posted Jun 21, 2017 11:05 AM

    Anyone has ever needed a query or function to list all child tasks of a specific parent task?

     

    I almost found what I needed in the following article:

    SQL Query for Parent Task 

     

    thanks for any help,

     

    Olivier



  • 2.  Re: SQL Query for all ChildTasks

    Posted Jun 21, 2017 11:45 AM

    The WBS_PARSEQ column contains the PRWBSSEQUENCE of its parent task (within the same PRPROJECTID) - you'd need to iterate though for a nested structure.