Multiple parent hierarchies in a Workfront report | Community
Skip to main content
T
TraKill
Level 3
July 27, 2026
Solved

Multiple parent hierarchies in a Workfront report

  • July 27, 2026
  • 1 reply
  • 28 views

Hi, I am trying to build a report including a parent task and it’s parent task to the subtask as well as the indicator ready to execute. Can someone tell me what the workaround is to add multiple parent task levels? Thanks you

Best answer by RandyRoberts

This code looks for any active child task whos parent, parent’s parent, parent’s parent’s parent, (5 deep) etc. is named Strategy, or Production, or Activation, or Development, or Intake. You can see the syntax for going up the chain of hierarchy. The ready to execute field is “canStart”.

description=Displays the Project Phase (Intake, Strategy, etc.) for each active task.
displayname=Phase of Active Tasks
listdelimiter=<br>
listmethod=nested(tasks).lists
type=iterate
valueexpression=IF({numberOfChildren}=0,IF({canStart},IF({status}="CPL","",IF({parent}.{name}="Intake"||{parent}.{name}="Strategy"||{parent}.{name}="Development"||{parent}.{name}="Production"||{parent}.{name}="Activation",CONCAT("Phase: ",{parent}.{name}),IF({parent}.{parent}.{name}="Intake"||{parent}.{parent}.{name}="Strategy"||{parent}.{parent}.{name}="Development"||{parent}.{parent}.{name}="Production"||{parent}.{parent}.{name}="Activation",CONCAT("Phase: ",{parent}.{parent}.{name}),IF({parent}.{parent}.{parent}.{name}="Intake"||{parent}.{parent}.{parent}.{name}="Strategy"||{parent}.{parent}.{parent}.{name}="Development"||{parent}.{parent}.{parent}.{name}="Production"||{parent}.{parent}.{parent}.{name}="Activation",CONCAT("Phase: ",{parent}.{parent}.{parent}.{name}),IF({parent}.{parent}.{parent}.{parent}.{name}="Intake"||{parent}.{parent}.{parent}.{parent}.{name}="Strategy"||{parent}.{parent}.{parent}.{parent}.{name}="Development"||{parent}.{parent}.{parent}.{parent}.{name}="Production"||{parent}.{parent}.{parent}.{parent}.{name}="Activation",CONCAT("Phase: ",{parent}.{parent}.{parent}.{parent}.{name}),IF({parent}.{parent}.{parent}.{parent}.{parent}.{name}="Intake"||{parent}.{parent}.{parent}.{parent}.{parent}.{name}="Strategy"||{parent}.{parent}.{parent}.{parent}.{parent}.{name}="Development"||{parent}.{parent}.{parent}.{parent}.{parent}.{name}="Production"||{parent}.{parent}.{parent}.{parent}.{parent}.{name}="Activation",CONCAT("Phase: ",{parent}.{parent}.{parent}.{parent}.{parent}.{name}),""))))))))
valueformat=HTML
width=200

 

1 reply

RandyRoberts
Community Advisor
RandyRobertsCommunity AdvisorAccepted solution
Community Advisor
July 28, 2026

This code looks for any active child task whos parent, parent’s parent, parent’s parent’s parent, (5 deep) etc. is named Strategy, or Production, or Activation, or Development, or Intake. You can see the syntax for going up the chain of hierarchy. The ready to execute field is “canStart”.

description=Displays the Project Phase (Intake, Strategy, etc.) for each active task.
displayname=Phase of Active Tasks
listdelimiter=<br>
listmethod=nested(tasks).lists
type=iterate
valueexpression=IF({numberOfChildren}=0,IF({canStart},IF({status}="CPL","",IF({parent}.{name}="Intake"||{parent}.{name}="Strategy"||{parent}.{name}="Development"||{parent}.{name}="Production"||{parent}.{name}="Activation",CONCAT("Phase: ",{parent}.{name}),IF({parent}.{parent}.{name}="Intake"||{parent}.{parent}.{name}="Strategy"||{parent}.{parent}.{name}="Development"||{parent}.{parent}.{name}="Production"||{parent}.{parent}.{name}="Activation",CONCAT("Phase: ",{parent}.{parent}.{name}),IF({parent}.{parent}.{parent}.{name}="Intake"||{parent}.{parent}.{parent}.{name}="Strategy"||{parent}.{parent}.{parent}.{name}="Development"||{parent}.{parent}.{parent}.{name}="Production"||{parent}.{parent}.{parent}.{name}="Activation",CONCAT("Phase: ",{parent}.{parent}.{parent}.{name}),IF({parent}.{parent}.{parent}.{parent}.{name}="Intake"||{parent}.{parent}.{parent}.{parent}.{name}="Strategy"||{parent}.{parent}.{parent}.{parent}.{name}="Development"||{parent}.{parent}.{parent}.{parent}.{name}="Production"||{parent}.{parent}.{parent}.{parent}.{name}="Activation",CONCAT("Phase: ",{parent}.{parent}.{parent}.{parent}.{name}),IF({parent}.{parent}.{parent}.{parent}.{parent}.{name}="Intake"||{parent}.{parent}.{parent}.{parent}.{parent}.{name}="Strategy"||{parent}.{parent}.{parent}.{parent}.{parent}.{name}="Development"||{parent}.{parent}.{parent}.{parent}.{parent}.{name}="Production"||{parent}.{parent}.{parent}.{parent}.{parent}.{name}="Activation",CONCAT("Phase: ",{parent}.{parent}.{parent}.{parent}.{parent}.{name}),""))))))))
valueformat=HTML
width=200

 

Terms & ConditionsAccessibility statement

Loading footer...