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

Question

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.

Richard_Le_ · Accepted Answer

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.

Madalyn_Destafney · Answer

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-on-reports/idc-p/661202#M24167

Sign up

Login with SSO

Login to the community

Login with SSO