Exists Statement to Filter Project Report Based on Assignments | Community

Level 2

Solved

Exists Statement to Filter Project Report Based on Assignments

Forum|Forum|27 days ago
March 11, 2026
1 reply
41 views

Hello, I am currently working on filtering a project report by task assignees manager. One of our design manager’s would like to see a full project report that is filtered for projects that their direct reports have been assigned tasks on. I think an exist statement would probably be the best way to do this but I could be overlooking something much simpler. If anyone has any suggestions that would be appreciated.

Text Mode Reporting

Best answer by abi_rains

oh this actually ended up working for me:

EXISTS:A:$$OBJCODE=TASK
EXISTS:A:projectID=FIELD:ID
EXISTS:A:assignmentsUsersMM:managerID=123
EXISTS:A:assignmentsUsersMM:managerID_Mod=eq

abi_rainsAuthorAccepted solution

Level 2

oh this actually ended up working for me:

EXISTS:A:$$OBJCODE=TASK
EXISTS:A:projectID=FIELD:ID
EXISTS:A:assignmentsUsersMM:managerID=123
EXISTS:A:assignmentsUsersMM:managerID_Mod=eq

Community Advisor

Community Advisor

Ah, this is great! For specifying the managerID, I subbed in the $$USER.ID wildcard. This made a report that any manager can pull up.

abi_rainsAuthor

Level 2

that is a great idea! thank you!