Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

Filter Projects by Owner's Teams

Avatar

Level 1

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

Topics help categorize Community content and increase your ability to discover relevant content.

1 Reply

Avatar

Level 10

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.