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

[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 ?

[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

[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.

1. 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.

2. If you need to filter out multiple statuses, use a query like "status NOT IN (Done, Closed, Resolved)".

3. 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".

4. 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]

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.