How to write a JQL that filters a user being assigned to custom multi-select-user field?

[Krzysztof Madejski]

I have a custom Approvers field that is a multi-select allowing to choose multiple JIRA users.

I wanted to offer any Approver a way to list all the tickets they need to approve. Sadly `"Approvers[User Picker (multiple users)]" in (Krzysztof Madejski)` doesn't work, `"Approvers[User Picker (multiple users)]" = Krzysztof Madejski` neither. It returns no tickets. Suprisingly also `"Approvers[User Picker (multiple users)]" is not empty` returns nothing.

[Bill Sheboy]

Hi @Krzysztof Madejski -- Welcome to the Atlassian Community!

Please try putting your name in double-quotation marks or use the account ID value in the query.

Or better still, as you want to share the query with other people, try using the JQL currentUser() function:

project = myProject
 AND "Approvers[User Picker (multiple users)]" IN ( currentUser() )
 ORDER BY Key ASC

Kind regards,
Bill

[Krzysztof Madejski]

I've tried both account ID and currentUser and they do not work. Maybe it depends on the fact how the field is configured.

[Bill Sheboy]

Hmm...

My understanding is the built-in "Approvers" field for JSM is not searchable in JQL, and you appear to have created a custom field with the same name.  I wonder how that impacts the search.