Expand my Community achievements bar.

SOLVED

Project Report - Column for Task user role and name

Avatar

Level 1

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)

1 Accepted Solution

Avatar

Correct answer by
Level 10

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

View solution in original post

2 Replies

Avatar

Level 10

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

Avatar

Correct answer by
Level 10

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