Show tickets where user is not present in multi user picker field

Danilo Simic

I would like to create a filter where all issues where I am not present in the "Phase 1 Local Approvals" field (multi user picker field).

 

The following JQL does not work:

"Phase 1 Local Approvals:[User Picker (multiple users)]" not in (xxx)

xxx is my user ID

 

However the opposite works fine (shows issues where I am present in that field):

"Phase 1 Local Approvals:[User Picker (multiple users)]" in (xxx)

 

Could this be a limitation from Jira?

Trudy P Claspill

In what way is the JQL not working?

When you have a field that can have multiple values if you want to find the issues where the field does not have a specific value and you also want the issues where the field has no value at all, then you need two criteria.

"Multiple User Picker[User Picker (multiple users)]" not in (xxx) or 
"Multiple User Picker[User Picker (multiple users)]" is empty

With a multi-select list when you use the operator "not in" the comparison between your specified values and the values in the field occurs only when the field actually contains values. If the field is empty, no comparison can be done, and so the issues with the empty field are not included in the result. You have to add the second criteria to also get the issues that have no value in the field.