Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

How to search for issues with an empty field (Issue Picker)?

Hi,

I have a field of type Issue Picker.

What is correct JQL query to find issues where my field is not populated?

Unfortunately "FIELD is Empty" doesn't work as Jira/ScriptRunner does not support searching for EMPTY values for issue picker.

1 answer

1 accepted

0 votes
Answer accepted

There is no way to do this I'm afraid.  It's a quirk of the search system in Jira and how it makes custom field plugins work - to enable the sub-set search for the issue picker, the code has to tell Jira the field is always populated, even when it's not (this is a terrible explanation, but I don't know how else to keep it simple)

How can we then search for issues with empty issue picker fields atm? Also a Scriptrunner Number Field doesn't seem to work in a JQL query (scriptRunnerNumberField = 0 returns all results, including such where the numer is other than zero).

You can't.  The issue picker field does not allow for it.

I'm not sure about the number field though, I don't get that, field = 0 returns issues where it's 0 to me.

Interesting. I got it to work using the following trick:

issueFunction in issueFieldMatch("", IssuePickerFieldName, "^$")

And yes, I also don't get what's wrong with the Number field. field = 0 returns issues where its 1 also. The searcher is set to Number Searcher, the template is Template Field. The code has only two exit points: return 0 at one place, return 1 at the other branch of execution.

Like Joey Musante likes this

Change the template to number, that should fix the field.

Only "Number field" exists in the drop down. I am not sure I know what you mean.

This is a Scriptrunner scripted field isn't it?  When you configure it, you get a big box for the script and then a select list for template underneath it?

Exactly. However, the template is called "Number field", not "Number". And it turns out that it usually works, but after a change of an issue which changes the number, and re-querying, the result of the query doesn't change, even though it should. Maybe some caching issue? I'll continue observing it, and when I have a working repro I'll write again.

Suggest an answer

Log in or Sign up to answer
TAGS
Community showcase
Published in Apps & Integrations

Send an Email or Publish to Confluence - What should you do with your release notes?

Background When you hear the words ‘Release notes’, almost always you think of an unsolicited email from a software vendor. But I am here to tell you that from our data, sending release notes via E...

138 views 1 2
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you