Creating a Project report based on Task Assignment Role/Team | Community
Skip to main content
SuryaLakhani
SuryaLakhani
February 25, 2025
Solved

Creating a Project report based on Task Assignment Role/Team

  • February 25, 2025
  • 1 reply
  • 524 views

Hi,

 

I am trying to create a project report based on the project containing tasks assigned to a particular team or role and the said tasks not being canceled. We have templates with Role and Team assignments so the Project User Role/Project User filters are not pulling in accurate data. I was trying to figure out how to do this with Exists filters but wasn't able to get to work. 

 

Wanted to see if anyone has any ideas on how to do this. Thanks!

Best answer by Sven-iX

Hi @suryalakhani 

In my example I use project:status = CUR

See if this example helps? 

EXISTS:a:$$EXISTSMOD=EXISTS
EXISTS:a:$$OBJCODE=TASK
EXISTS:a:OR:1:teamID=65c377cb000c55996086696fb63dbd1c
EXISTS:a:OR:2:roleID=64d51cce0134c709b8730f9655a14f4b
EXISTS:a:projectID=FIELD:ID
status=CUR

 

1 reply

Sven-iX
Community Advisor
Sven-iXCommunity AdvisorAccepted solution
Community Advisor
February 28, 2025

Hi @suryalakhani 

In my example I use project:status = CUR

See if this example helps? 

EXISTS:a:$$EXISTSMOD=EXISTS
EXISTS:a:$$OBJCODE=TASK
EXISTS:a:OR:1:teamID=65c377cb000c55996086696fb63dbd1c
EXISTS:a:OR:2:roleID=64d51cce0134c709b8730f9655a14f4b
EXISTS:a:projectID=FIELD:ID
status=CUR

 

    Terms & ConditionsAccessibility statement

    Loading footer...