JQL query to check if at least 1 of a group of users is present in a User Picker Multiple field

Syd Skaff

I have 3 users who all have the authority to sign off on tickets and record their names in a User Picker (multiple) field. I need a way to query for issues that do not contain at least 1 of these people's names in the field. In other words, I need to find all issues that do not contain user1 or user2 or user3. Note that there may be other names in the field (user4, user5, etc.) and I would still want the query to show these issues.

Humashankar VJ

Hi @Syd Skaff 

Try this JQL and see whether it suits your requirement,

"Approvers" NOT IN (user1, user2, user3) OR "Approvers" IS EMPTY

To validate the Approvers field, two conditions are used, NOT IN (user1, user2, user3) checks that none of the three authorized users are selected, while IS EMPTY verifies that the field hasn't been left blank.

This approach is particularly effective for User Picker fields that allow multiple user selections.

Hope this helps - Happy to help further!!
Thank you very much and have a great one!
Warm regards