A report list of Projects and roles names assigned in tasks

[wfnoob]

Hi,

I am trying to create a report that list all active projects and roles that have tasks assigned to them.  So it would look something like this:

Project A

Dev Role name (Instead of Suzy Bee)

Test  Role

PM Role

Project B

PM Role

Dev Role

Infrastructure Role

I created a Task report and added the Assigned To column with :role:name to show the role name instead of the person's name.  That works, however AssignedTo only has 1 person assigned to it, whereas Assignment will list out all individuals assigned to the tasks.  I did the same thing and appended role name to assignment:role:name, but that column ends up being blank.

Like this: 

displayname=Assignments Role
linkedname=assignments
namekey=view.relatedcolumn
namekeyargkey.0=assignments:role:name
namekeyargkey.1=assignments:role:name
querysort=assignments:role:name
textmode=true
valuefield=assignments:role:name
valueformat=HTML

I'm new to workfront, and hope I've explained what I'm after correctly.

thanks

[skyehansen · Accepted solution]

You would need to reference a collection of assignments in your report view. I hope this link will help you understand why that is, as well as teach you how to construct that type of column.

https://experienceleague.adobe.com/docs/workfront/using/reporting/reports/text-mode/reference-collec...

the code would look something more like this:

valueformat=HTML
textmode=true
type=iterate
listdelimiter=<p>
displayname=Assignments Role
listmethod=nested(assignments).lists
valuefield=role:name

[wfnoob]

Thank you for the explanation and links. That was the solution!