Forums

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

JQL filter one or both fields empty

Astrid Uttenreitter March 19, 2020

Hi

I am trying to filter for issues where priority and/or original estimation is empty. Currently the filter is only returning the issues where one of the fields is empty, but not if both are empty. What should i change to get the correct filter?

Here is what i have now: 
project = PMO AND status in (Approval, Open) AND (originalEstimate != EMPTY OR priority != EMPTY)

1 answer

1 accepted

2 votes
Answer accepted
Thomas Schlegel
Community Champion
March 19, 2020

Hi  @Astrid Uttenreitter 

I think, your JQL should look like this:

project = PMO AND status in (Approval, Open) AND (originalEstimate is EMPTY OR priority is EMPTY)

Astrid Uttenreitter March 19, 2020

Thanks Thomas - that seemed to do the trick :) 

Thomas Schlegel
Community Champion
March 19, 2020

you're welcome, @Astrid Uttenreitter 

Suggest an answer

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

Atlassian Community Events