Multiuser Custom Field and membersOf() JQL function

[Davin Studer]

I have a multi user custom field called "System Owners" and I want to write a filter that will pull back any issues where any members of the System Owners field are not in a certain group. I tried the below JQL.

"System Owners" not in membersOf(the group)

At first I thought this was working because I got results, but then I realized that I think it is only showing issues where ALL of the people in "System Owners" are not in "the group". I would like to find a way to report where any of the users in the multi-user field are not in "the group". Does anyone have any great ideas for this? Or is it just not doable with built-in JQL?

[Irfan Mazli Mazuki · Accepted solution]

Hello @Davin Studer,

It seems like it's not possible to achieve the requirement in the built-in JQL. The outcome seems to be an expected behavior since the "System Owners" in the JQL will be treated as a whole entity, which is why the outcome was ALL the "System Owners" members that are not in "the group" rather than ANY of the "System Owners" members that are not in the group.

I have tried to look for an alternative JQL available in the default JIRA but it does not seem there are any. You may want to look into some plugins that can extend the JQL capabilities in JIRA:

• JQL Tricks Plugin
• JQL Search Extensions for Jira
• JQL Functions Collection