Skip to main content
Level 2
Aug 23, 2024 9:31 PM UTC
Solved

Filter projects based on owner team ID

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.

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
skyehansen
skyehansenAccepted solution
Aug 26, 2024 4:04 PM UTC

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-teams-not-just-home-team/m-p/500944/highlight/true#M32694

 

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.)

4 replies

skyehansen
Adobe Champion and Community Advisor
Aug 24, 2024 12:50 AM UTC

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

Translate
Level 2
Aug 24, 2024 12:20 PM UTC

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.

Translate
skyehansen
Adobe Champion and Community Advisor
skyehansenAdobe Champion and Community AdvisorAccepted solution
Aug 26, 2024 4:04 PM UTC

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-teams-not-just-home-team/m-p/500944/highlight/true#M32694

 

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.)

Translate