how to get names of sprint in jira for last one year

[Siddharth Shukla]

I want to get names & Ids of All sprints created in last one year in specific project.

Add on will be if we can get mapping with board/team.

[Danut M _StonikByte_]

Hi @Siddharth Shukla,

Be aware that the sprints are linked to an agile (Scrum) board, not to a project!

Here are some ways to get the sprints of a board:

By using  the Jira REST API.  

This is a more "technical" method, but probably the more convenient. Simply open a URL like this in your browser: https://MY_JIRA_BASE_URL/rest/agile/1.0/board/BOARD_ID/sprint 

BOARD_ID is the ID of your agile board. To find it, open your agile board in Jira and take the ID of the rapidView from the browser's address bar.

When open the URL in your browser, it will return details about the sprints of the board in JSON format. Use the Pretty-print option of the browser (Chrome in my example).

By using the Velocity Chart report of the agile board

Open the agile board, go to Reports (press 3) and select the Velocity Chart report. Choose Time frame: Custom and set the time frame.

To get the ID of the sprints, hove the mouse over the sprint, and note its ID in the browser's status bar.

Danut.

[Jack Brickey]

I don't know of a direct way of achieving. You could use a filter like below to find all issue that were completed in sprints sine the beginning of the year. Then you could use excel or sheets to find all unique sprints but there are holes in the process.

Project = xxxx and Sprint IS NOT EMPTY and resolutiondate >= startOfYear()

maybe there is something within the APIs that could help.