Expand my Community achievements bar.

SOLVED

anyone has as built an hour report with 'other teams' filter in text mode

Avatar

Level 4

We have a hour type report type which a team was using but they need an ability to filter by teams mentioned in other teams. eg: other teams has team A, team B, team C and I want a filter where I want to see all users on an hour type report to only see where users who belong to team A show up.

1 Accepted Solution

Avatar

Correct answer by
Community Advisor

Hey,

 

Just come across this thread trying to find a solution to filtering for "other teams" myself. Seems like a common ask! I've managed to pull together a text mode filter that should enable you to filter by an hour owner's other teams as follows:

 

EXISTS:1:$$EXISTSMOD=EXISTS
EXISTS:1:$$OBJCODE=USER
EXISTS:1:ID=FIELD:ownerID
EXISTS:1:teams:ID=**INSERT TEAM ID HERE**
EXISTS:1:teams:ID_Mod=in

 

Best Regards,

Rich.

 

View solution in original post

3 Replies

Avatar

Community Advisor

This is a common desire and I've wanted this myself. Other Groups is available for hour reports but not Other Teams, who knows why. I've tried using Other Groups to tweak in text mode for Other Teams but not having any luck. I haven't seen a workaround for this in the Community. Please upvote this Idea! https://experienceleaguecommunities.adobe.com/t5/workfront-ideas/add-other-teams-as-a-filter-option-... 

If this helped you, please mark correct to help others : )

Avatar

Correct answer by
Community Advisor

Hey,

 

Just come across this thread trying to find a solution to filtering for "other teams" myself. Seems like a common ask! I've managed to pull together a text mode filter that should enable you to filter by an hour owner's other teams as follows:

 

EXISTS:1:$$EXISTSMOD=EXISTS
EXISTS:1:$$OBJCODE=USER
EXISTS:1:ID=FIELD:ownerID
EXISTS:1:teams:ID=**INSERT TEAM ID HERE**
EXISTS:1:teams:ID_Mod=in

 

Best Regards,

Rich.

 

Avatar

Community Advisor

 

Very nice, @Richard_Le_!

 

For further investigation (#notetoself @Doug_Den_Hoed__AtAppStore)...

 

  • Given the _Mod=in, it might be possible to provide multiple Team IDs (e.g. Team A and Team C, although I suspect they would then be treated as an OR)

And/or (pardon the pun)...

 

  • It would be interesting to try combining this with the $$USER.teamIDs Wildcard filter

 

Regards,

Doug