The field value when empty is bot being captured in the jql

[Apoorva Sharma]

Hi Team,

We have been trying to fetch the details of issue using a 'jql' which includes a where clause for CustomField of type Number field such that if the value in the field is empty/null/0 then only we should be able to get all the issues.

the jql being used:
project = [projectkey] issuetype in (Story, Requirement) AND ( [customfield] = null OR [customfield] is EMPTY )

But we are unable to fetch certain issues for projects even when the [customfield] value is empty for those.

Can someone please let me know what could be done to get value for the empty fields?

[John Funk]

Hi Apoorva - the null is not going to work and is not needed. 

project = [projectkey] AND issuetype in (Story, Requirement) AND [customfield] is EMPTY

Does that get you want you want? And if not, then what is different?