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

[Jyo_Mohanraj]

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.

[Madalyn_Destafney]

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

[Richard_Le_ · Accepted solution]

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.

[Doug_Den_Hoed__AtAppStore]

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