Retrive All Projects childs and childs of childs

(0) Share

Report

Posted on by Omar Abdelhamed Dev

105

in project managment i wanna get all projects childs and childs of childs

for ex proj1 - proj1-1 - proj1-1-1 - proj1-2

* proj proj1-1 , proj1-2 childs of proj1

* proj1-1-1 child of proj1-1

i wanna retrive all in one query ,, any help ?

I have the same question (0)

All responses (4)

Answers (1)

Sort by

Gunjan Bhattachayya 35,423 on at

Like (0)

Report
Copy link

Link copied!

Hi Omar,

Where are you going to display the result of this query you are trying to write?

Was this reply helpful? Yes No
Omar Abdelhamed Dev 105 on at

Like (0)

Report
Copy link

Link copied!

you can say i need to display them in info .. how can i find all childs and sub childs

Was this reply helpful? Yes No
Verified answer

Gunjan Bhattachayya 35,423 on at

Like (0)

Report
Copy link

Link copied!
Hi Omar,

You can try with a job like this and check if that works for you.

static void displayProjHierarchy(Args _args) { ProjTable projTableParent, projTableLoc; List projList; Enumerator en; str projStr; List getChildProjectsFromRootProject(ProjId _projId, List _projList) { ProjTable projTable; while select projTable where projTable.ParentId == _projId { _projList.addEnd(projTable); if (projTable.ProjBudgetManagement == ProjBudgetManagement::None && ProjTable::child(projTable.ProjId)) { getChildProjectsFromRootProject(projTable.ProjId, _projList); } } return _projList; } while select projTableParent where projTableParent.ParentId == '' { projStr = projTableParent.ProjId; projList = new List(Types::Record); getChildProjectsFromRootProject(projTableParent.ProjId , projList); en = projList.getEnumerator(); while (en.moveNext()) { projTableLoc = en.current(); projStr = ">" projTableLoc.projId; } info(projStr); } }

Was this reply helpful? Yes No
Omar Abdelhamed Dev 105 on at

Like (0)

Report
Copy link

Link copied!

it's working ,, thanks a lot Gunjan

Was this reply helpful? Yes No