Can I search for a list of completed Sprints

[Fred W]

My manager has asked me to list all the sprints and releases we have completed in 2020 is there a search function i can use to dashboard that information? We use Jira server 7.13 and scriptrunner 

[Walter Buggenhout · Accepted solution]

Hi @Fred W,

Jira search will give you a set of issues. But since they are associated with sprints and releases, I guess this approach will get you close to what you need:

First, create a filter containing the issues resolved in 2020. Let's assume they are part of project AB:

 Project = AB and Resolved >= StartOfYear()

Save the filter. On a dashboard, add 2 two dimensional issue statistics gadgets.

Use the filter as your data source for both gadgets. Select the following dimensions as the X and Y axes for the gadgets:

• Issue Type and Sprint for the first gadget
• Issue Type and Fix Version for the second gadget

You can of course replace Issue Type with any other dimension (e.g. project) to narrow down the result to what suits best.

[Walter Buggenhout]

Oh,

to narrow down your search, you can limit the selection of sprints or releases to just the ones that were completed:

for sprints

Project = AB and resolved >= StartOfYear() and sprint in ClosedSprints()

for releases

Project = AB and resolved >= StartOfYear() and and fixVersion in releasedVersions()