JQL for all done statuses

[Nate Dickinson]

How do I write a JQL query to pull done statuses? By this I mean all green status types. That for me in our instance includes some of the following as an example: 

• done
• complete
• canceled 
• rejected 
• deployed
• etc

Is there a query that will let me use one line that will handle all of these current statuses and any that come up in the future ? This would also be helpful for the future when a new done status may be added. 

[Bill Sheboy · Accepted solution]

Hi @Nate Dickinson 

Please try using the statusCategory for the issues instead:

statusCategory = Done

Also please note, if you are using any Scrum boards: the statusCategory is not used to determine if an issue is completed for a sprint.  Instead it checks for issues in a status mapped to the column at the right side of the board.  This is a valuable thing to check for board configurations as sometimes teams have more complicated boards which do not put the "done" statuses at the far right.

Kind regards,
Bill

[Nate Dickinson]

Thank you Bill. That should work.