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 ?
it's working ,, thanks a lot Gunjan
Hi Omar,
You can try with a job like this and check if that works for you.
Share
Report
All responses (
Answers (
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);
}
}
you can say i need to display them in info .. how can i find all childs and sub childs
Hi Omar,
Where are you going to display the result of this query you are trying to write?
#1
André Arnaud de Cal...
294,459
Super User 2025 Season 1
#2
Martin Dráb
233,066
Most Valuable Professional
#3
nmaenpaa
101,158
Moderator
