Project Report based on Other Teams List | Community
Skip to main content
MoniqueEvans
Community Advisor and Adobe Champion
MoniqueEvansCommunity Advisor and Adobe Champion
Community Advisor and Adobe Champion
September 4, 2020
Question

Project Report based on Other Teams List

  • September 4, 2020
  • 1 reply
  • 1093 views

I'm trying to make a project report but filter to users within a specific team. The assignments aren't team assignments and the team is not the user's home team but in their other teams list. Any ideas? I feel like this might need to be an EXISTS report, but none of the connections I've tried seem to be working. Anyone have any ideas? And this has to be a project report; an assignment report grouped by project would be too much data to sift through.

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

    1 reply

    imgrund
    Adobe Employee
    imgrundAdobe Employee
    Adobe Employee
    September 8, 2020

    We need an EXIST that skips to levels. I can get it to the user object type (Project -> Project User -> User), but we need it to Teams (Project -> Project User -> User -> Team).

    @Jason Webre‚ - Have you figured out how to skip two levels on an EXIST filter?

    Can get this to work:

    EXISTS:1:$$OBJCODE=PRTU

    EXISTS:1:projectID=FIELD:ID

    EXISTS:1:user:homeTeamID=535849aa001bafe3bc58afeb2f238b03

    But really want the condition to be something like

    EXISTS:1:user:teams:ID=535849aa001bafe3bc58afeb2f238b03

    I tried jumping straight to USER but then what on the User profile ties it back to the project ID?

    J
    Adobe Employee
    JasonWe2Adobe Employee
    Adobe Employee
    September 9, 2020
    I'm stumped on this one!
    S
    SarahNa
    Level 6
    September 9, 2020

    Hey Monique - if you just want home team would this work?

    Terms & ConditionsAccessibility statement

    Loading footer...