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

Project Report based on Other Teams List

  • September 4, 2020
  • 1 reply
  • 1086 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!
    A
    AnthonyMe1
    Level 2
    September 9, 2020

    I've come up with two examples of code that don't cause a "Whoops" error, which is usually a good sign when using EXISTS, but they also don't return any results. I think the problem is the second line in each example. It seems that linking based on a field in a collection (project users) of the originating object (project) just doesn't work. I can't think of any way to write this without having to rely on the Project Users collection.

    In case anyone is curious and wants to see if they can wrestle with it and get it to work, here's my code:

    Example 1: linking directly to the User table

    EXISTS:A:$$OBJCODE=USER

    EXISTS:A:ID=projectUsers:FIELD:userID

    EXISTS:A:teams:ID=5187e2630000521e3068f29c80cb175b

    Example 2: linking to the Team Member table

    EXISTS:A:$$OBJCODE=TEAMMB

    EXISTS:A:userID=projectUsers:FIELD:userID

    EXISTS:A:teamID=5187e2630000521e3068f29c80cb175b

      Terms & ConditionsAccessibility statement

      Loading footer...