Project Report with Task Collection of Assignments by Job Role

[MoniqueEvans]

Hey everyone!

I am currently using this text mode on my project reports to pull a collection of who is assigned to tasks.

displayname=Tasks Assigned To

listdelimiter=<br>

listmethod=nested(tasks).lists

textmode=true

type=iterate

valueexpression=IF({numberOfChildren}=0,CONCAT({assignedTo}.{name}))

valueformat=HTML

But I'm wondering if any text mode gurus know of a way to take this to the next level and only show names if their job role is Graphic Designer ({user}.{roleID}="5519cc8500268d3218df43252bc5c135") or Digital Designer({user}.{roleID}="5579b4500070c1f6e13374b692ba9895").

Also for extra fun, is there a way to pull the collection of assignment users instead of the assigned to?

[AnthonyIm]

Hey,

Here you go

displayname=Tasks Assigned To

listdelimiter=<br>

listmethod=nested(tasks).lists

textmode=true

type=iterate

valueexpression=IF({numberOfChildren}=0,IF({assignedTo}.{roleID}="5519cc8500268d3218df43252bc5c135",CONCAT({assignedTo}.{name}),IF({assignedTo}.{roleID}="5579b4500070c1f6e13374b692ba9895",CONCAT({assignedTo}.{name}),"")),"")

valueformat=HTML

I don't know how to do assignments in a collection. But I do have some code for a filter.

It is Projects Where I Have Incomplete Assignments

EXISTS:1:$$OBJCODE=ASSGN

EXISTS:1:assignedToID=$$USER.ID

EXISTS:1:assignedToID_Mod=in

EXISTS:1:projectID=FIELD:ID

EXISTS:1:task:status=CPL

EXISTS:1:task:status_Mod=notin

You could repurpose that to be something like Projects Where Graphic Designers have Incomplete Assignments

EXISTS:1:$$OBJCODE=ASSGN

EXISTS:1:roleID=5519cc8500268d3218df43252bc5c135

EXISTS:1:assignedToID_Mod=in

EXISTS:1:projectID=FIELD:ID

EXISTS:1:task:status=CPL

EXISTS:1:task:status_Mod=notin

[AnthonyIm · Accepted solution]

I lied to you... ;)

EXISTS:1:$$OBJCODE=ASSGN

EXISTS:1:roleID=5519cc8500268d3218df43252bc5c135

EXISTS:1:roleID_Mod=in

EXISTS:1:projectID=FIELD:ID

EXISTS:1:task:status=CPL

EXISTS:1:task:status_Mod=notin

[MoniqueEvans]

"Hey Google, play Mariah Carey's Hero"

Thank you thank you thank you!!! I knew it had to be something simple but my brain just wasn't putting 2 and 2 together.

[ChristinaPi4]

Hello Monique! 

I tried adding this to one of the project reports but I kept getting an error. Have you had this happen? The only addition I had was a range of entry dates. 

Thanks!

Christina