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.

[Krzysztof Madejski]

Attlassian support helped:

> Your project is set up as a Jira Software project. Unfortunately, the built-in "Approvals" feature isn't compatible with Jira Software projects. This functionality is currently only available in Jira Business and Jira Service Management projects. This is why you're not seeing anything when trying to filter by approvers in this project.

[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.