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

This widget could not be displayed.

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.

Thanks!!

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
Atlassian Summit 2018

Meet the community IRL

Atlassian Summit is an excellent opportunity for in-person support, training, and networking.

Learn more
Community showcase
Posted yesterday in New to Jira

Are you planning to trial, or are currently trialling Jira Software? - We want to talk to you!

Hello! I'm Rayen, a product manager at Atlassian. My team and I are working hard to improve the trial experience for Jira Software Cloud. We are interested in   talking to 20 people planning t...

71 views 1 0
Join discussion

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