Filter Projects by Owner's Teams | Community
Skip to main content
K
KhrystyneVa1
February 25, 2022
Question

Filter Projects by Owner's Teams

  • February 25, 2022
  • 1 reply
  • 561 views

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.

    This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

    1 reply

    R
    Community Advisor
    Richard_Le_Community Advisor
    Community Advisor
    March 2, 2022

    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.

      Terms & ConditionsAccessibility statement

      Loading footer...