Project Report - Column for Task user role and name

Question

I wanted to know if you can generate a column within a project report to show specific user roles who are assigned tasks in the project and then have their name populate in that field. (Example - QA Lead - John Smith)

lgaertner · Accepted Answer

Ok, wow...I think I just accidentally stumbled upon a (partly) solution, when reading this thread. As all assigned users to tasks under a project can also be queried using the projectUsers collection, you can use something like this:valueexpression=CONCAT({user}.{role}, " - ",{user}.{name})listdelimiter=

listmethod=nested(projectUsers).listsvalueformat=HTMLdisplayname=Assigneesdescription=Assigneestextmode=truetype=iterate I am quite sure, that the limitation, you will need to live with is, that you will only get the primary role of the users. RegardsLars

lgaertner · Answer

Hello,

I think that will not be possible in general as you would need to query collections in multiple "layers", which could lead to a timeout.

But, as you also can read here,

You cannot build a collection view of another collection.
For example, you cannot display all the assignees on each task in a project report. You can only display the primary assignee on each task in a project view.

Regards

Lars

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded