How to search for status types - e.g. yellow, blue, green - "To Do", "In Progress", "Done"?

Stephen Casey_iw57tj

I'd like to write a query that finds all issues in a project that are currently in the backlog, all that are in delivery and all that are done.  The way I know these statuses is the green/blue/Yellow colours in the workflow - is that data available anywhere to JQL or would I have to write the query to explicitly include every status?

 

E.g. I have, Demand Plan (to do), Backlog (to do), In Development (in progress), Testing (in progress), UAT (in progress), Done (done) - something like (meta):

select where project = Myproject and status.type = "in progress" 

 

should give me anything in myproject that's "in development", "Testing" or "UAT"...?

Alex Christensen

The status category is searchable in JQL. For example:

project = "My Project" and statusCategory in ("In Progress")

This should return any issue in "My Project" that has a status in the "In Progress" category (in your case, that would include statuses "In Development," "Testing," and "UAT").