Exposing all Predecessor task owners, whether individual or group | Community
Skip to main content
R
Ryan_McGee
Level 5
February 15, 2023
Solved

Exposing all Predecessor task owners, whether individual or group

  • February 15, 2023
  • 1 reply
  • 649 views

I am working on a report that shows a team's future tasks (wildcard filter on home team, Can Start=N) and have been able to hack together columns to show the previous task and its planned completion date. I can even get the assignment to show up if it's an individual. But I can't make anything show up if it's a team assignment.  I went into the API developer site and believe this is what I need, but nothing is displaying. The flags (shown below) suggest a limitation, but I want to confirm with the group. Again, I want to show the predecessor owner whether it's a team or an individual. Thanks in advance!

 

Current code that shows individuals, I tried inserting "assignmentsListString" where the itals are:

displayname=Predecessor Owner

listdelimiter=<br>

listmethod=nested(predecessors).lists

textmode=true

type=iterate

valueexpression={predecessor}.{assignedTo}

valueformat=HTML

 

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by Richard_Le_

Hi Ryan,

 

You could try the following instead:

 

displayname=Predecessor Owner listdelimiter=<br> listmethod=nested(predecessors).lists textmode=true type=iterate valueexpression=CONCAT({predecessor}.{assignedTo},IF(ISBLANK({predecessor}.{team}.{name})||ISBLANK({predecessor}.{assignedTo}),"",", "),{predecessor}.{team}.{name}) valueformat=HTML

 

What this value expression is doing is Concatenating the values "assignedTo" and "team.name" together. There's also an IF ISBLANK statement in there to output a comma between assignedTo and team name if they are not blank.

 

One thing to point out however, is that this will not work where there are multiple teams assigned to the predecessor. It will only show the primary team. Since you are referencing a collection (predecessors), and teams is also a collection, i don't believe Workfront will let you report on a collection within a collection (if that makes sense). I suspect that is why the assignmentsListString attribute you mention is not working in this report. 

 

Anyway, give my code a go and let me know how you get on.

 

Best Regards,

Rich. 

1 reply

R
Community Advisor
Richard_Le_Community AdvisorAccepted solution
Community Advisor
February 15, 2023

Hi Ryan,

 

You could try the following instead:

 

displayname=Predecessor Owner listdelimiter=<br> listmethod=nested(predecessors).lists textmode=true type=iterate valueexpression=CONCAT({predecessor}.{assignedTo},IF(ISBLANK({predecessor}.{team}.{name})||ISBLANK({predecessor}.{assignedTo}),"",", "),{predecessor}.{team}.{name}) valueformat=HTML

 

What this value expression is doing is Concatenating the values "assignedTo" and "team.name" together. There's also an IF ISBLANK statement in there to output a comma between assignedTo and team name if they are not blank.

 

One thing to point out however, is that this will not work where there are multiple teams assigned to the predecessor. It will only show the primary team. Since you are referencing a collection (predecessors), and teams is also a collection, i don't believe Workfront will let you report on a collection within a collection (if that makes sense). I suspect that is why the assignmentsListString attribute you mention is not working in this report. 

 

Anyway, give my code a go and let me know how you get on.

 

Best Regards,

Rich. 

    R
    Ryan_McGeeAuthor
    Level 5
    February 15, 2023

    If we ever meet, I'm buying you a beverage of your choice. That did it!

    R
    Community Advisor
    Richard_Le_Community Advisor
    Community Advisor
    February 15, 2023

    Hi Ryan,

     

    That's great! I'll settle for you marking my answer as correct so that others know the solution works in the future 😁.

     

    Have a great day!

     

    Best Regards,

    Rich. 

    Terms & ConditionsAccessibility statement

    Loading footer...