How to search for all tickets that are not done

[Sharon Burns]

Our organizations have several teams that use Jira and many different statuses for each team and each project in Jira.
Is there a way to search for tickets that have any status that is considered completed/done?
For example, one team may use the term "deployed" status for done, another team may use the term "moved to prod" for done.
Rather than having to know and select all the different statuses, is there a way to show me all the statuses that are considered done?

Thank you!!

[John Funk · Accepted solution]

Hi Sharon - Welcome to the Atlassian Community!

I am going to assume that you are aware that all statuses fall into one of three categories - To Do, In Progress, and Done. And will also assume that the statuses you describe as being considered Done are actually Done category statuses. 

So, you should be able to use statusCategory = Done to see all Done type statues. That's one word with no space in it. 

[Sharon Burns]

THIS WORKED!
Thank you!

[John Funk]

Great! Happy to help. 

[Evgenii]

You can try:

resolution IS EMPTY

or another JQL

Status NOT IN (Completed, Done)

Fully agree with @Manoj Gangwar, request depends from how you measure issues as "not done"

[Manoj Gangwar]

Hi @Sharon Burns ,

Jira defines "resolved" as having a resolution set.  Jira Software boards consider "done" to be "in the last column on the board". 

JQL- project = xyz and status in (Deployed, Moved to Prod)

Technically, done and resolved are different things, but a standard recommendation for most Jira projects is to set the workflow so that they co-incide.  

JQL- Project = xyz and resolution = Done

[Evgenii]

sorry, wrong thread for my answer.