anyone has as built an hour report with 'other teams' filter in text mode | Adobe Higher Education
Skip to main content
Level 3
March 12, 2024
Resuelto

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

  • March 12, 2024
  • 2 respuestas
  • 722 visualizaciones

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.

Este tema ha sido cerrado para respuestas.
Mejor respuesta de Richard_Le_

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.

 

2 respuestas

Madalyn_Destafney
Community Advisor
Community Advisor
March 20, 2024

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 

If this helped you, please mark correct to help others : )
Richard_Le_Community AdvisorRespuesta
Community Advisor
May 15, 2024

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
Community Advisor
Community Advisor
May 15, 2024

 

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