Filter Projects by Owner's Teams

[KhrystyneVa]

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.

[Richard_Le_]

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.