AnsweredAssumed Answered

Project and Parent SQL

Question asked by ben.jones on Aug 20, 2012
Latest reply on Aug 21, 2012 by Owen_R
I'm trying to write some sql that lists the id, project name, and then the name and id of the parent directly above it in the hierarchy. The project above it in the hierarchy must also not be a program, which i've figured out.

Infact, I've managed to bring back parent information but as soon as the parent is then below another project in the hierarchy, it brings back the proejct at the top of the hierarchy, rather than the project directly above it in the hierarchy.

I also want there to only be row in my results for each project - so I don't want multiple rows if the project is directly under multiple projects.

Does anyone know of anything available for this?

Ben

Outcomes