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?
It's the difference between "null" and "not what you're looking for".
Try (component != RTS or component is empty) - that should pull back 39
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.
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.
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!
Unfortunately there are no AUG chapters near you at the moment.Start an AUG
We're bringing product updates and pro tips on teamwork to ten cities around the world.Save your spot