How to exclude Jira tickets that are Closed, Story Done, Cancelled, Resolved etc

[Ranjan Koirala]

I am trying to find the tickets with duedate now that are not in closed, cancelled, resolved and Story Done status.

project = "XXXX" AND duedate <= now() AND status not in (Closed , resolved, Cancelled, "Story Done")

this doesn't seem to be working?

[John Funk · Accepted solution]

Hi Ranjan,

Try using statusCategory != Done to show all issues not in a Done type status.

[Trudy Claspill]

Hello @Ranjan Koirala 

How is your filter not working? Are you getting an error? Do the results not include issues you think should be included? Do the results include issues you think should not be included?