JQL to find "done" issues

[Gina Nace]

I'm creating a testing board and I want it to pull in all issues marked "done"  from another project. I can't seem to find the right jql to make this work. Any suggestions?

[Jack Brickey]

you need to define "done". Is done the ending status?

If so and you have multiple projects then you will want to ensure you include all of the final statuses, e.g. DONE, CLOSED, RESOLVED. So look at each project and determine this then add to your JQL as ...status in (done, closed, resolved...).

Often "done" means that the issue has been resolved and that there is a Resolution value. In this case your jql would be ... AND Resolution is not Empty. But if any project does not require the Resolution code then you must factor that in.

you could end up w/ something like this...

projects in (a,b,c) AND (Resolution is not Empty OR Status in (x,y,z))

[John Funk]

Hi Gina,

Try project = xxx and status = Done

[Gina Nace]

That works when I try to filter issues off one project, but when I plug in a different project I don't get any results...even though there are about 100 issues marked done in the my active sprint board. Does it matter that the done issues are sub-tasks?

[John Funk]

Your board has a base filter associated with it. If there is a project identified in that base filter, you would have to change out the base filter to see another project. 

Alternatively, you could have a bit more of a generic base filter than then use the sub-filter on the board to identify the project. 

It does not matter what type of issues they are - all issues should show up unless your filter singles out specific issue types.