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?
Solved! Go to Solution.
Topics help categorize Community content and increase your ability to discover relevant content.
Views
Replies
Total Likes
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
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
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
"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.