Expand my Community achievements bar.

SOLVED

Grand Parent or Parent's Parent Task to show in own column on a Report

Avatar

Level 3
Spoiler
 

Hi All! Hoping someone can help me figure out the right Text Mode configuration to pull in a task's Grand Parent name into it's own separate column. Within our projects many tasks have overarching Grand Parent tasks, then a Parent task, then a specific task assigned to a user. What I need is a way to include what that Grand Parent task name is on an Hour Report.

 

I figured out how to group by this information, but the particular report I am working on currently needs to have this information in a separate column. 

 

Any ideas on this would be really appreciated!!

1 Accepted Solution

Avatar

Correct answer by
Community Advisor

try this:

displayname=grandparent
linkedname=task
namekey=view.relatedcolumn
namekeyargkey.0=task
namekeyargkey.1=parent:parent:name
querysort=task:parent:parent:name
textmode=true
valuefield=task:parent:parent:name
valueformat=HTML

 

All I do is take the Task | ParentID field from standard mode, change this to text mode, and change out the "ID" part for ":parent:name"

View solution in original post

6 Replies

Avatar

Level 5

See if this works for you.

 

displayname=Grandparent Task Name
textmode=true
valueexpression={parent}.{parent}.{name}
valueformat=HTML

Avatar

Level 3

No, unfortunately it didn't work. Thank you so much though for replying!

Avatar

Level 5

This is what I get using that code (screenshots of test project and report results).

 

family project.pngfamily report.png

 

 

Avatar

Level 3

I think it may be because it's on an Hour report, and not a Task report as I previously said (my mistake!). I'm working on a report someone else created, but if I can't get it to work on the hour report I may just create a new report as a better work around. Thanks again!

 

Avatar

Correct answer by
Community Advisor

try this:

displayname=grandparent
linkedname=task
namekey=view.relatedcolumn
namekeyargkey.0=task
namekeyargkey.1=parent:parent:name
querysort=task:parent:parent:name
textmode=true
valuefield=task:parent:parent:name
valueformat=HTML

 

All I do is take the Task | ParentID field from standard mode, change this to text mode, and change out the "ID" part for ":parent:name"

Avatar

Level 3

That did it! Thank you so much for all your help, everyone!