Exposing all Predecessor task owners, whether individual or group

[RyanMcGee]

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

[Richard_Le_ · Accepted solution]

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. 

[RyanMcGee]

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

[Richard_Le_]

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.