JQL for querying users not in a group

Patrick Van Tassell

Hello all, 

I am trying to find a query for all tickets that have been assigned to a group, but not someone in that group. 

Finding the opposite of "membersof" seems to be the issue here.  I have tried numerous placements of not and ! and have not been able to find a solution.

Something like the following, but "not" is where the query fails: 

assignee changed by not membersof("DevOps Team")to membersof("DevOps Team")

 Thanks in advance!

Ivan Lima

Hi @Patrick Van Tassell, you mentioned a few different pieces in your question, so I'll try to break those down into separate parts.

Find issues where assignees are not a member of a particular group. You can look at the membersOf function to get additional insights.

assignee not in membersOf("DevOps Team")

Find issues where the assignee was changed by a user who is a member of a particular group. Note that the previous assignees, and the current one, don't necessarily need to be the user who changed the assignee field.

assignee changed by membersOf("DevOps Team")

You can do the opposite by adding NOT at the beginning of the statement. In this case, you will get all issues except the ones where the assignee was changed by a user who is a member of a particular group.

NOT (assignee changed by membersOf("DevOps Team"))

I hope that all make sense.