A report list of Projects and roles names assigned in tasks

Question

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 Answer

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-collections-report.html?lang=en

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

displayname=Assignments Rolelistmethod=nested(assignments).listsvaluefield=role:name

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded