Project Report based on Other Teams List

Question

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.

imgrund · Answer

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?

Sign up

Login with SSO

Login to the community

Login with SSO