nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Strange query results

Eddy Borremans

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?

Accepted answers

Nic Brough -Adaptavist-

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

All comments

Nic Brough -Adaptavist-

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

rambabu patina

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

Eddy Borremans

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

Eddy Borremans

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!

Eddy Borremans

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

Eddy Borremans

Question was properly answered by Nic Brough.

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira

cloud

jira-cloud