AnsweredAssumed Answered

Project / Program / Portfolio hierarchy query

Question asked by beekerc2 on Dec 8, 2009
Latest reply on Sep 11, 2012 by Dale_Stockman
Does anyone have, or can give me guidance to write, a SQL script (hopefully without recursion) that will allow me to start with a project, program or portfolio ID and return me a list of the child tree structure, as well as the parent tree structrure (only so far as it's related the selected item being a lowest child, with a direct path to the root?  I'm writing a process that needs to manually roll up figures across a hierarchy, so I'm starting with the script to determine what other projects, programs and portfolios need to be adjusted.  ThanksBeekerC

Outcomes