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)
Solved! Go to Solution.
Views
Replies
Total Likes
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=<div>
listmethod=nested(projectUsers).lists
valueformat=HTML
displayname=Assignees
description=Assignees
textmode=true
type=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.
Regards
Lars
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
Views
Replies
Total Likes
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=<div>
listmethod=nested(projectUsers).lists
valueformat=HTML
displayname=Assignees
description=Assignees
textmode=true
type=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.
Regards
Lars
Views
Likes
Replies
Views
Likes
Replies