


Does anyone know of a way to build a filter for a report based on the project owner's other teams? I see how we can filter by the owner's home team, but none of the filters seem to work if I want to search based on any other teams assigned to that owner.
Topics help categorize Community content and increase your ability to discover relevant content.
Hi Khrystyne,
I believe that you would need to build an exists filter to achieve this. The below should work:
EXISTS:1:$$EXISTSMOD=EXISTS
EXISTS:1:$$OBJCODE=USER
EXISTS:1:ID=FIELD:ownerID
EXISTS:1:teams:ID=abc123
EXISTS:1:teams:ID_Mod=in
You would just need to replace my 'abc123' with the ID of the team that you want to filter on. Regardless of whether or not this team is a project owners home team or other team, the filter will still return all projects that are owned by people within that team. If that makes sense!
Hope this helps!
Best Regards,
Rich.