Strange query results

In JIRA I am trying to select a subset of issues in order to do some bulk changes. However, my issue search queries give me strange results.

project = SDRD -> returns 120 issues

project = SDRD and component = RTS -> returns 81 issues

project = SDRD and component != RTS -> returns 7 issues where i would expect 120-81=39 issues.

What am i doing wrong?

3 answers

1 accepted

This widget could not be displayed.

It's the difference between "null" and "not what you're looking for".

I suspect

  • you've got 81 issues with RTS as a component.
  • you've got 7 issues with at least one other component, but not RTS.
  • you've got 32 issues with no component set at all

Try (component != RTS or component is empty) - that should pull back 39

Hi, Please check with the JQL: project = SDRD and component is Empty. The remaining issues will come.

@Nic, thanks for your answer, this solved my problem. I will spend the remainder thinking about the exact why ;-)

Hmmm, it looks like since some issues do not have a component at all, they seem not to be incorporated in the query at all. Apparently 'component != 'RTS' should be read: all issues that have a component and the component is not equal to RTS. From a query perspective this still feels counter intuitive to me. Maybe i should study the internal model of Jira, but for now my immediate problem has been solved. Thanks!

That's not so much a function of Jira as a more general point about data.

We humans tend not to distinguish between "null" and "not X" whereas computers very much have to. To us, it's intuitive that the question "show me everything where the component is not X" should return all the empty lines as well, but that's not how data works.

It's hard to explain that a "simple yes or no question" has three possible answers when the statement itself says that there's only two. There's always Yes, No and no-answer given. I don't know if this is a language thing (I'm English, and to my shame, speak no other languages, so I don't know if questions phrased in other languages might be less fuzzy or less loaded implications)

Obviously, you can change the question to state it explicitly - "if you don't answer, we have to assume you mean "no"". And, you have to do this with the computers as well.

This is not going to change - if you implicitly assume "no includes no-answer", then you lose the ability to find issues where no component has been set. There is a difference between "not x" and "empty/null" and it's a useful one. But we have to remember to be clear about it. And I forget it ALL the time, despite having worked with computers for <mumble> decades.

This widget could not be displayed.

Hehe, it's getting academic now, but the underlying issue has intrigued me no end while i was still a computer science student. Too bad i am not that well versed in formal mathematics. First i learned from logics that all statements are either true or not true. Until someone showed me the statement : 'i always lie'. Im not sure if this would fall in the category 'not true' or if we should at a 'indeterminate' value which is neither false nor true. My gut feeling has always told me that basic mathematics cannot properly model these statements, but im sure that by now math has found a way to deal with it. I however, have never been able to get my head around it. In any case it is indeed very important to clearly specify the exact models that are used including assumptions. Unfortunately these systems (JIRA) should of course also be usable by non-math experts. And that I guess is where this whole Q&A feature comes in.

Thanks for your help anyway.

Eddy

This widget could not be displayed.

Question was properly answered by Nic Brough.

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 Aug 06, 2018 in Jira Service Desk

A is for Activate: Share your top Jira Service Desk onboarding tips for new users!

Hi, everyone! Molly here from the Jira Service Desk Product Marketing Team :).  In the spirit of this month's  august-challenge, we're sourcing stories of Jira Service Desk activation fro...

573 views 25 15
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