Help with text mode on project report - need to include all users assigned to a task | Community
Skip to main content
Laura-MC
Laura-MC
Level 2
August 30, 2021
Solved

Help with text mode on project report - need to include all users assigned to a task

  • August 30, 2021
  • 2 replies
  • 1266 views

Does anyone know if/how I can modify this Project report to include ALL users that are assigned to a task? It currently only displays those that are assigned as "Primary". This report displays all projects in which a user is assigned a task (the task/project will fall off the report once marked complete). However, if more than 1 user is assigned to a task within a project, that project will only display on the primary user's report. Thanks in advance!

Text Mode:

OR:1:ownerID=$$USER.ID

OR:1:ownerID_Mod=in

OR:1:statusEquatesWith=PLN CUR ONH APR

OR:1:statusEquatesWith_Mod=in

statusEquatesWith=PLN CUR ONH APR

statusEquatesWith_Mod=in

tasks:assignedToID=$$USER.ID

tasks:assignedToID_Mod=in

tasks:statusEquatesWith=CPL

tasks:statusEquatesWith_Mod=notin

Best answer by ChloeRo

Laura - if you're still having issues, I find that sometimes when I copy and paste codes from the internet, I need to delete the spaces between the statusEquatesWith statuses (PLN CUR ONH APR) and redo the spacing using the tab key. Just an idea! That has definitely tripped me up before. Text mode can be very humbling 😂

2 replies

imgrund
Adobe Employee
imgrundAdobe Employee
Adobe Employee
August 30, 2021

Hi - since it is a project report, you will need to do an EXISTS filter so you can go to the assignment object type (not just task). Here is one I have saved.

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

So you should end up with something like this for your final code :)

OR:1:ownerID=$$USER.ID

OR:1:ownerID_Mod=in

OR:1:statusEquatesWith=PLN CUR ONH APR

OR:1:statusEquatesWith_Mod=in

statusEquatesWith=PLN CUR ONH APR

statusEquatesWith_Mod=in

EXISTS:1:$$OBJCODE=ASSGN

EXISTS:1:assignedToID=$$USER.ID

EXISTS:1:assignedToID_Mod=in

EXISTS:1:projectID=FIELD:ID

EXISTS:1:task:statusEquatesWith=CPL

EXISTS:1:task:statusEquatesWith_Mod=notin

    Laura-MC
    Laura-MCAuthor
    Level 2
    August 30, 2021

    Thanks Anthony! I tried that EXIST filter and the report now doesn't populate any results. I'll take a deeper dive into the filter and see if I can make sense of it :)

    Laura-MC
    Laura-MCAuthor
    Level 2
    September 20, 2021

    Chloe - that worked!!!! Thank you SO SO much :) Laura

    T
    Tom2600
    Level 2
    April 21, 2023

    Can somebody help me, I am trying to just pull all names that are assigned across all tasks within a project (but not duplicate them) and format it to look like this too in HTML

    * Name 1, Role Title (div)
    * Name 2, Role Title (div)
    * Name 3, Role Title (div)

     
    THIS DOESN'T SEEM TO WORK
    description=Assigned Resources Names TXT
    displayname=Assigned Resources Names TXT
    listdelimiter=<div>
    listmethod=nested(assignedToID).lists
    textmode=true
    type=iterate
    valueexpression=CONCAT("* ",{user}.{name})
    valueformat=HTML
      Terms & ConditionsAccessibility statement

      Loading footer...