Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

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

Krzysztof Madejski June 26, 2025

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.

2 answers

0 votes
Krzysztof Madejski July 2, 2025

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.

0 votes
Bill Sheboy
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
June 26, 2025

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 June 27, 2025

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
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
June 27, 2025

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.

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
STANDARD
TAGS
AUG Leaders

Atlassian Community Events