Skip to main content
MoniqueEvans
Adobe Champion, Community Advisor, UG Leader
MoniqueEvansAdobe Champion, Community Advisor, UG Leader
Adobe Champion, Community Advisor, UG Leader
March 11, 2022
Solved

Project Report with Task Collection of Assignments by Job Role

  • March 11, 2022
  • 4 replies
  • 1266 views

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.
    Best answer by imgrund

    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
    imgrundAdobe Employee
    Adobe Employee
    March 11, 2022

    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

      imgrund
      Adobe Employee
      imgrundAdobe EmployeeAccepted solution
      Adobe Employee
      March 11, 2022

      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

        ChristinaPisell
        ChristinaPisell
        Level 2
        October 22, 2024

        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

        Terms & ConditionsAccessibility statement

        Loading footer...