I need help with creating a Jira search query. I’m working on a project where I have to find all tickets that have empty values in a specific custom field. I’ve been trying different approaches but can’t seem to get the right syntax.
I was thinking there might be some kind of operator I can use, maybe something like “is empty” or a combination with wildcards. Has anyone dealt with this before? I’m looking for a way to identify all issues where my custom field called “Release Version” has no data entered.
Any suggestions on the proper JQL syntax would be really helpful. Thanks in advance for any tips or examples you can share!
To find issues with empty values in the “Release Version” custom field, you can use the JQL syntax “Release Version” is EMPTY. This syntax effectively targets tickets lacking any input in that field. Moreover, it applies to various custom field types such as text fields and date fields. If your custom field name has spaces or special characters, ensure you enclose it in quotes. The EMPTY criterion considers both fields that were never filled and those that were cleared. This method is useful during sprint planning or when tidying up project data.
yeah, EMPTY works great, but you can also use “Release Version” is null for tickets where the field was never set. sometimes there’s a difference between empty and null depending on your custom field setup.
Try using “Release Version” ~ EMPTY instead - it catches edge cases that the standard is EMPTY misses. I’ve seen custom fields with whitespace or hidden characters that look empty but aren’t actually null. The tilde operator handles these better. You can also combine operators: “Release Version” is EMPTY OR “Release Version” is null to catch all empty variations. Really helpful with imported data or fields that got changed multiple times.