Filter projects based on owner team ID

[Namratha_p]

Hi All, 

When we create a projet report, we have a filter available to filter out the projects based on Owner Home team ID = $$user.hometeamID or $$USER.teamIDs. But, can anyone help with how to write a text mode to also include owners other team ID = $$user.hometeamID or $$USER.teamIDs.

[skyehansen]

I'm not sure I understand what your current filter does. Are you able to copy and paste it into your post?

[Namratha_p]

The usecase is when I login, I need a report which shows all projects all users who belong to my team or who belong to my other teams.

But, with the current filter, it only pulls if the users home team ID is either equal to my team or my other teams. So, I am looking for additional one which also pull if users other team ID = My home team or my other team ID. Or looking for any other solve.

Example: User A Home team ID = 1

Other team ID = 2, 3

My home team ID =2 

Other team ID= 3

 When I open the report, I also want the User A projects to show up, because they belong to atleast one of my teams. But, with the above filter, it doesnot work, as it is only filtering out based on users home team ID.

[skyehansen · Accepted solution]

Ahhh, I see. Instead of the filter you're showing, I would suggest you experiment with the one in this post:

https://experienceleaguecommunities.adobe.com/t5/workfront-questions/filter-on-assignment-users-team...

My guess is that you'd want something similar to Jason's solution, but just change it to look at the owner ID. So it might look something like this:

EXISTS:A:$$OBJCODE=TEAMMB
EXISTS:A:teamID=$$USER.teamIDs
EXISTS:A:userID=FIELD:ownerID

(This is just a guess of course, but give it a shot and see how it goes.)

[Namratha_p]

Thank you, yes this looks like this is working. Have asked our stakeholders to confirm.