Need to generate a report on completed tasks from past sprints

[Ashley Swearingen]

I need to generate a report that shows completed tasks from past, completed sprints. I'm able to run a report that shows all open tasks that were moved into the next sprint but I need to see a list of all the tasks that were completed in past sprints. Is this possible? 

[Trudy Claspill · Accepted solution]

Hello @Ashley Swearingen 

Does this get you what you want?

project=<your project> and resolution is not empty and sprint in closedSprints()

[Ashley Swearingen]

That didn't work for me 

[Trudy Claspill]

Hello @Ashley Swearingen 

Can you show us exactly what you used and explain how it "didn't work"? Did you get an error message? Did you not get the results you expected?

If you replaced <your project> with your own project identifier then it should've given you all the issues from that project that had a value in the Resolution field (indicating work is complete) and that were assigned to a Sprint that has been closed.

[Ashley Swearingen]

The problem might be that our sprints from multiple projects. I will try to search for one project. 

[Ashley Swearingen]

Yep! that worked. Do you know if it's possible to search multiple projects?  

[Trudy Claspill]

Yes, change the criteria thus:

project in (<comma separated list of projects>) AND...

[Ashley Swearingen]

I promise, I tried that 50 times before and it didn't work but it works now. Thank you, @Trudy Claspill !! 

[Trudy Claspill]

You're welcome!

If your questions have been answer, please mark the answer as Answer Accepted to help other community members find the posts that include solutions.