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; } } }

How do I filter out issues where status is done

Duane Steyn

I am writing a filter where, amongst other criteria, it filters out issues that have status done. Here is the revelant part in JQL. It still shows issues where status is "Done".

project = Q24

AND type = Subtask

AND Status IN ("To Do", "In Progress", Pending)

AND assignee IN (712020:c1a9d850-96c8-4116-8180-8c436b0e59f0, empty)

What am I doing wrong. I also tried negative statement, NOT IN "Done" and it did not work either

Accepted answers

All comments

Mohanraj Thangamuthu

Hello, Good day. I don't see you have used 'OR' anywhere and only "AND' is used. Is it possible for you to share a screenshot ?

Muhammad Moazzam Hassan

project = "Q24" and statusCategory != Done (This Query will retrieve the issues which are not in the state of Done, Resolved, Closed or Any status in Green Box)

project = "Q24" and statusCategory = Done (This Query will retrieve the issues which are in the state of Done, Resolved, Closed or Any status in Green Box)

Evgenii

Hi, @Duane Steyn

There are different ways to achieve what you want, each varying in logic.

Use a JQL query like "status != Done" to exclude issues with a specific status. This works when you know the exact status to filter out.
If you need to filter out multiple statuses, use a query like "status NOT IN (Done, Closed, Resolved)".
To filter all statuses in a specific category (there are three: To Do, In Progress, Done, each with a distinct color—grey, blue, and green), use the JQL query "statusCategory != Done".
If you're unsure of the exact status names or there are too many, and you set a resolution when an issue reaches a final status, you can use the query "resolution IS NOT EMPTY". It's good practice to set the resolution upon issue closure since it influences Jira's logic for counting productivity.

Duane Steyn

Mohanraj Thangamuthu

You are using 'OR' in this JQL that is the reason. Create the JQL only with 'AND' function, this should help. Thanks

Evgenii

You have many OR's in the end of JQL, for payment type field. They are messing with all other query conditions.

Write your full JQL, we can correct it.
Here is similar question, where OR changed results (and way of fixing it)
https://community.atlassian.com/t5/Jira-questions/Filter-creation/qaq-p/2817859#M1053180

Duane Steyn

Hi.
I have tried the following:

AND status != Done

as well as

AND status NOT IN (Done) as well as positive IN statements and it does not filter out the Issues that have status done. I have attached screen shots on Mohanraj's post below.

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