Expand my Community achievements bar.

Interested in getting an Adobe Workfront certification? Don't miss our AMA on June 10th, where our experts will be available to answer any questions you may have about getting certified!
SOLVED

A report list of Projects and roles names assigned in tasks

Avatar

Level 1

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

1 Accepted Solution

Avatar

Correct answer by
Community Advisor

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

View solution in original post

2 Replies

Avatar

Correct answer by
Community Advisor

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

Avatar

Level 1

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