Filter query for members of a team

[rwheeloc]

I'm trying to create a filter query that finds work assigned to members of a team across different projects.

It seems like I should be able to accomplish this by creating a team, adding the appropriate people to it, and then using a filter query like this:

assignee in membersOf("Team Name")

However Jira does not recognize "Team Name" as a group as expected by the membersOf() function, even though the Team exists with that name.

I have been able to get it to work using a string like this:

assignee in (member1,member2,member3...)

But this seems like it will be a headache to manage as people move on or off the team.

Any better way to accomplish this?

Thanks!

[Trudy Claspill · Accepted solution]

Hello @rwheeloc 

Welcome to the community.

How did you define the Teams and their members? If it was the Team option under the People menu, that is not an entity that can be used in filters.

membersOf only works for User Groups. You would have to create your Team as a User Group.

[Mikael Sandberg · Accepted solution]

Hi @rwheeloc,

Welcome to Atlassian Community!

The membersOf() function only works on groups, not the new Team feature that you find under People. So what you can do is create a new group and then your search with membersOf() should work. 

[Sheri Widler]

Is there a query something like: 

memberof "Team[Team]"   

using the shared team function in advanced roadmap/plans?  

I want to look up assignee by Team[Team] and assign the team based on the assignee 

[Mikael Sandberg]

@Sheri Widler Currently the answer is no, teams in advanced roadmaps is not available outside of advanced roadmaps. You should be able to do it once the new Atlassian Teams has been rolled out, you can learn more about it here.

[C. Dicker]

I think this feature request is what you are looking for:
[JRACLOUD-81400] Add support for membersOf JQL function for Teams - Create and track feature requests for Atlassian products.

[rwheeloc]

Thanks Trudy and Mikael - looks like you were both right. I'd used the Team option under the People menu. I'd hoped there was a way to use the membersOf() function with a Team (since I do not have sufficient admin privileges to create a Group) but it sounds like that is not possible.

[Steve Rapaport]

And even if you had permissions to create a Group, it would have the same problem you mentioned above, rwheeloc:  The team changes month to month, and you'd have to keep updating the Group manually.

The only real solution is to expose the Team of each People.

[Sandra_Abi-Khalil]

Yes, this would have been very helpful! Currently I'm struggling to even understand the point of the Teams feature in Jira, if you can't even use it for this.

[Trudy Claspill]

To all who have commented on or are watching this thread, there are changes coming to the Teams functionality.

Check out this article:

https://community.atlassian.com/t5/Advanced-Roadmaps-articles/Teams-in-Advanced-Roadmaps-What-s-changing-and-what-you-need-to/ba-p/2259096