JQL Search query: Issues that have been assigned to users not part of specific group

Hi,

I've been unsuccessfully trying to find a way to run a search for issues that have at some point been assigned to any user that is not part of a specific group. This seemed simple enough, but I have not yet found a way to do this.

1.: Search for issues that were at some point assigned to a user not part of group x. Query: assignee was not in membersOf(x)

Problem: Returns only issues that have never been assigned to anyone in group x. I require all issues that were at some point not assigned to anyone in group x. (preferably barring unassigned, but this can be worked around)

2.: Okay, let's then reverse this instead and search for: issues that were never assigned to anyone not part of group x.

Problem: Query does not seem to exist! Something like "assignee was not outside membersOf(x)" would be necessary, but the inverse of a group is not something I have found a syntax for.

I can think of workarounds in the form of manually changing the status of every past/present/future issue or adding every single JIRA user not part of group x to a group "not x". However, I consider the former an unwanted burden on workflows and unwanted addition to the system, and the latter is/will eventually produce a big administrative mess.

Any options?

Kind regards,

Sonny

1 answer

I guess that's not possible. The only way which comes into my mind is to write a plugin with a new jql clause for that (maybe there is already a plugin for that?): https://developer.atlassian.com/display/JIRADEV/Plugin+Tutorial+-+Adding+a+JQL+Function+to+JIRA

Sorry I cannot help you any further. :-(

Any progress on that?
(Please tell people with similar issues if your issue could be solved.)

No progress here, unfortunately. Getting someone to look into writing a plugin as you suggested (thanks for the feedback!) might be something I will have to look into at in the near future but do not have the resources for at this moment.

As for similar questions/plugins: Possibly this post will provide some leads on creating a plugin that allows searching for users not part of a specific group: https://answers.atlassian.com/questions/81598/script-runner-get-users-not-in-jira-users-group

However if this search really is not possible at the moment (besides plugins) I do wonder if either or both search options shouldn't/couldn't be implemented in JIRA itself. Especially not having a way to search for "users not member of group x" seems like a simple little gap in the available search functionality.

If I find a way, I will add it to this issue.

Suggest an answer

Log in or Sign up to answer
How to earn badges on the Atlassian Community

How to earn badges on the Atlassian Community

Badges are a great way to show off community activity, whether you’re a newbie or a Champion.

Learn more
Community showcase
Published Thursday in Jira

5 ways you can make the most of Jira Software and Bitbucket Cloud

As part of the Bitbucket product team I'm always interested in better understanding what kind of impact the use of our tools have on the way you work. In a recent study we conducted of software devel...

70 views 0 5
Read article

Atlassian User Groups

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

Find a group

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

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you