How do I filter custom fields with value null in URL query

Let's say I have a list of issues. But some of them have a custom field with value null in my json ("customfield_number":null), since it's optional. How can I filter issues with only non null custom field?


I tried


But none of these affected the results, at all...

1 answer

1 accepted

1 vote
Answer accepted
Radek Dostál
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.
Aug 18, 2022 • edited

The second url says "is not empty" but you are searching for null. Could it be you meant

 "customfield" IS EMPTY



Assuming that api/2/search jql param works the same way as typing it out to navigator (you can do the same with /issues/?jql= ..) then above should be working.

Also, it's part of the jql - not a separate parameter, so

?jql=project = <key> and cf[12345] is empty&maxResults=1000


Trying locally that seems to do the work.

I need to filter out values with null, I'm not searching for null. I need all issues where customfield is not null

If I try to modify the URL like above I get error code 400


EDIT: Thank you so so so much! It finally works after a day of failure, the way you said that customfield_nr is part of the jql query clicked something in me!! So my query looks like this


```search?jql=project=key+and+cf[id]+is+not+empty``` with plus signs in between

Suggest an answer

Log in or Sign up to answer