Creating a Project report based on Task Assignment Role/Team

[SuryaLakhani]

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!

[Sven-iX · Accepted solution]

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