Project Report based on Other Teams List

[MoniqueEvans]

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.

[AnthonyIm]

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?

[JasonWe2]

I'm stumped on this one!

[MoniqueEvans]

It makes me feel better that both of you are struggling with this one as well. I spent an embarrassing amount of time trying ideas and couldn't find a way to connect project user to user's teams. I would settle for home team but I don't think there's a way to connect that either.

@Anthony Messam‚ - Do you have any ideas??

[SarahNa]

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

[AnthonyMe1]

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

[MoniqueEvans]

Thanks everyone!! This just gave me an idea that I'm going to try a little late when my brain is more awake. 😁

I just remembered we have a user custom form that I could try to use and make this one jump instead of two. I'm hoping it will allow me to make the jump from "project assigned to user" to "user custom field" by way of user ID.