Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Finding issues assigned to all members of current user's groups with JQL

How can we find issues assigned to all members of current user's groups with JQL?

2 answers

0 votes

You can't do this directly, no-one has written a JQL clause for "user in groups that a named user is in", probably because it's mostly useless.

The closest you can get is what Fazila said - use the "membersOf" to define which groups you are interested in.

The reason a search for other user groups is useless is that 99.9% of Jira installations have groups that include all the users, so a search for "users who are in the same groups as I am" is always going to return everyone.

We've tried something else in the past with a scripted JQL function and a set of groups meant to identify the user's team. For instance, we had groups like Team-QA, Team-Dev, Team-Designer, and each user belonged to exactly one of these teams. The JQL was used like this: issueFunction in assignedToMyGroup("Team")

The function then checked the current user's groups, found the one that starts with the prefix "Team" and performed the query: assignee in membersOF("Team-Dev").

It worked, but it was a hassle. It takes a lot of overhead to manage groups with about a thousand users and make sure everyone is in the right group and ONLY the right group. Performances were not good. Maintenance was not fun and it broke often. So I wouldn't recommend it.

Better approach: A script listener and a Team custom field. Basically, when there's an update to an issue's assignee, the script updates the Team field according to a mapping, like if the team is Team-Dev, the Team field is set to Dev. Then it's just a simple JQL like "Team = Dev" to get the issues assigned to a member of a specific team. Users can even have a nice dashboard with Rich Filter and use a dynamic filter to pick the team. This can be easily done in Automation too, so it's simpler for project admins to maintain it. 

It's not dynamic since it doesn't auto-detect the user's team, but as long as users are able to select their own team, the results is the same. Either way, there's no magic here, a careful management of the groups is needed for any of this to be useful. 

0 votes
Fazila Ashraf Community Leader May 20, 2021

Hi @Zahurul Islam 

I am not sure whether you can do a current user's group which is dynamic. But if you know the group already, you can do something like below:

assignee in membersOf("jira-administrators")

Thanks. Actually I want to make a dashboard where everyone can view only the issues that are assigned to his/her groups, not to other groups. So I need a JQL query to make a filter where current user's groups will be got dynamically for membersOf("") function. Otherwise I have to make separate dashboards for different groups.

John Funk Community Leader May 21, 2021

Try this: Assignee = currentUser() and assignee in membersOf("jira-administrators")

Like Mervin Britoe likes this

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
STANDARD
PERMISSIONS LEVEL
Site Admin
TAGS
Community showcase
Published in Jira Software

👋 Looking for 15-20 volunteers to test Atlassian training content

Hi everyone! Are you interested in beta testing Atlassian University’s newest (unreleased!) training course? We’re looking for 15-20 volunteers to test our newest training course, Basic reporting...

442 views 19 23
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you