Query returning wrong results

project = "XXXX" AND issuetype != Epic AND component != none AND Status was Done during ("2017/05/01" , "2017/07/31")


picks all the results prior to even 1st Jan. What is wrong with the query?

1 answer

Try using:

(After ("2017/05/01") And Before ("2017/07/31"))

instead of During.

:-(  Does not work..

Hi Rajiv,

I had a similar issue too. I think there is no issue with the date but rather with the way Jira understands the not equal relational operator (!=). I am not 100% sure on why it happens, to be seems like a Jira bug. Anyways you should try a reverse logic something like this -

project = "XYZ" AND issuetype in (Epic, Story, Improvement) and (component in ( 'ABC','Whatever','Impediments','People','Process','Program','Sprint Review',,'Teams', "Tools & Technology ") or component is Empty) ## and add any other codition you want to

the point is instead of saying component !=none (as in your case), say component = << everything else>>

I hope this works, atleast it did for me. But I agree it is not logical in the first place that why your query did not work.


It's not a bug, but it's not intuitive for humans.

When you ask about the values of contents of a field, you need to look at the content first.  The question "is the colour field red?" works ok when your field has red in it, or green, or has no value at all.  But when you ask "is the colour field not red?", you'll get what you expect when it's red or green, but it can't answer when there is no colour there.  So it fails the test.  Humans expect it to succeed because we usually (wrongly) equate "no answer" with "abscence".

The thing to do is catch it explicitly.  You can do "component = <<everything else>>", but in most cases, you probably want to say "component is not empty"

Suggest an answer

Log in or Sign up to answer
Community showcase
Published Jan 08, 2019 in Jira

How to Jira for designers

I’m a designer on the Jira team. For a long time, I’ve fielded questions from other designers about how they should be using Jira Software with their design team. I’ve also heard feedback from other ...

1,091 views 4 9
Read article

Atlassian User Groups

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

Find a group

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

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you