Skip to main content
MoniqueEvans
Adobe Champion, Community Advisor, UG Leader
Adobe Champion, Community Advisor, UG Leader
Mar 11, 2022 6:43 PM UTC
Solved

Project Report with Task Collection of Assignments by Job Role

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?

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
imgrund
imgrundAccepted solution
Adobe Employee
Mar 11, 2022 9:10 PM UTC

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

4 replies

imgrund
Adobe Employee
Adobe Employee
Mar 11, 2022 9:09 PM UTC

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

Translate
imgrund
Adobe Employee
imgrundAdobe EmployeeAccepted solution
Adobe Employee
Mar 11, 2022 9:10 PM UTC

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

Translate
ChristinaPisell
Level 2
Oct 22, 2024 8:43 PM UTC

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

Translate