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.

[Nick H]

This is technically possible since when you go to a team's page you see "Team activity" ...

Atlassian, what is the query being used to populate that widget? That's what we all want

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

[Aaron Gage]

"Advanced Roadmaps" is less advanced than you might interpret.  Frankly, it's pretty immature and borderline useless.

[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

[Maksim Beliaev]

@Trudy Claspillhow is this related to this post? what is the JQL to find all the issues assigned to one of the team members ?

[Trudy Claspill]

It relates because the OP created a Team under the People menu, and there are changes coming to unify those Teams and the Shared Teams previously available only under the Plans (Advanced Roadmaps) functionality.

I did not see anything in the article about changes to filtering functionality for members of Teams.

After scouring the 5 pages of comments on the article, I found that somebody mentioned there is a change request about supporting Team members with the membersOf function.

https://jira.atlassian.com/browse/JRACLOUD-81400