Can someone help to find the Sprint ID (s) between dates for a specific project?

Sathya Shankar

We have several projects and during the period of transition, we had several projects having different naming conventions without a running ID or start/end Dates; and these may be ONE or TWO or THREE week sprints. 

I want to list the sprint Names and sprint ID between dates for a specific project. Can someone help?

Earl McCutcheon

Hello Sathya,

On the front end checking the start end end dates of the prints is going to be on a sprint by sprint basis in the sprint reports of the board.  Something that may help a bit in locating the sprint names but not the ID's is that have the option of using the advanced JQL functions openSprint() and closedSprint(). Though this will not display the exact dates of the sprint when querying issues so this would only help narrow down the results and you would still need to review each sprint listed to collect the date ranges manually as some of the results will be outside of the update ranges because the sprint field can have multiple results if an issue is included in multiple sprints. 

• openSprints()
• closedSprints()

On this method you could add the sprint column to the issue navigator and use a JQL like the following to get all the issues that were updated in a specific timeframe to help narrow down the result set that also belong to a sprint:

project = ProjectA AND updatedDate >= "YYYY/MM/DD HH:MM" AND updatedDate <= "YYYY/MM/DD HH:MM" AND Sprint is in closedSprints()

Another approach here would be to look at the API endpoint to "Get all boards" for a list of all boards, this endpoint will give you an indication of which projects are associated to which boards specified as the query argument (projectKeyOrId) for your project. Afterwards you can use "Get sprint" API call to get the details on all the sprints for each board tied to the project in question which will include the "startDate" and "endDate" for all the sprints on the board.

Regards,
Earl