Project Report with Task Collection of Assignments by Job Role | Community
Skip to main content
MoniqueEvans
Community Advisor
MoniqueEvansCommunity Advisor
Community Advisor
March 11, 2022
Solved

Project Report with Task Collection of Assignments by Job Role

  • March 11, 2022
  • 2 replies
  • 1198 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

    2 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...