Jira: How can I find out the sprint ID of a particular sprint?

[Fabian Gautschi]

Hi everyone!

I want to set a filter that filters for issues which are in a particular sprint in Jira. For that purpose I need the sprint ID of a particular sprint. How can I find out the sprint ID of a particular sprint?

Thanks for your help!!

[EddieW · Accepted solution]

The hack i found was to view the sprint report for an active/closed sprint.

/secure/RapidBoard.jspa?rapidView=4&view=reporting&chart=sprintRetrospective&sprint=1

The global Sprint ID will showup in the URL. I would really love AtLSSIAN to add a simple link that jumps to issue navigator, pre-filtered like the old boards did.

[SabrinaB]

Thanks Eddie, you've helped me on this one!

[Nikhil Joshi]

Hi Eddie,

Is there a sprint id associated with a future inactive sprint as well? For example, during sprint planning I create a new sprint on the Plan tab for different boards. Then I am writing a jql to pull out issues from "Next" sprints in every board but seems like jira/greenhopper only creates a sprint ID for active sprints?

Cheers,

Nikhil

[EddieW]

@nIKHIL, you should start a new question for this topic. But in short no, the future sprints in the planning view are actually called "markers", and I do not think they are available via JQL- https://answers.atlassian.com/questions/52688/how-to-use-rapid-board-s-sprint-marker-in-jql-query, but you can get the list of issues in a future sprint from the rest api.

Also note that there should be a link in planning view on markers that says something like "view in inssue navigator"

[C. Ross McKenrick]

I don't think this works anymore. But this works: https://confluence.atlassian.com/display/AGILEKB/JIRA+Agile%3A+How+to+search+for+a+Sprint+using+JQL

[PoojaJ]

Thanks Eddie this really saved my time

[Ramprasad]

Thank you!!

[Bhumika Parikh]

@EddieW that did not work for me. My current sprint that I wanted to use had "16" at the end. I did a bulk change to edit about 7 issues to link to this sprint by typing "16" and it linked them to a completely different sprint from over a year ago.

[Maciek Pawlowski]

Alternatively, if you create a new query and type in Sprint = "Whatever", JIRA will replace "Whatever" with the sprint number.

[Jamie Powell-Smull]

Awesome. This is straight forward and easy. It gave me my furture sprint id.

[Evgeny Erofeev]

does not work

[Joseph Murphy]

Worked for me!

[Haris Kamil]

worked for me! thanks!!

[John Veneruso]

This works, but you have to wait a moment for the "autosuggestions" to appear below the JQL entry box and then move the mouse cursor, click on the autosuggestion, and voila, your autosuggestion that was identical to your sprint name is mysteriously replaced in the JQL entry area with the sprint ID.  (This is very non-intuitive)  I also looked for a column titled Sprint ID that I could simple add to the Issue Query output.  Alas, this doesn't exist in the column possibilities. 

Note:  This wouldn't be such a big problem if it weren't for the compounding restriction in Bulk Update that only Sprint ID's can be used in the Sprint field.

[Aidan McPeake]

That was very useful. Thankyou Maciek Pawlowski

[Gautam De]

@Maciek - This works. Terrific. Thanks a lot

[John Smith]

Hover over the 'Future Sprint' link in a jira that is planned and the id will be shown in the URL link at the foot of your browser.

[Corey Scott]

Failing this. You can use web developer tools and "Inspect element" on the sprint name. The sprint id is a property of the div container

[Kyle Anderson]

Corey's comment did the trick for me.

[andros1337 NA]

Open that link(Future sprint) in the new tab. You'll see sprint param in the url which is sprint id

[Deleted user]

Inspect element worked for me - thanks!

[Paulina Guzik]

Corey, thanks a lot! It works.

[Skowronek]

The fact one has to open up the developer tools to look up the sprint id in the code in order to obtain the Jira Sprint ID for the bulk transition to another sprint is asinine. Perhaps Atlassian can make it easier to locate the sprint ID in the transition jiras tool so one does not waste time trying to identify the ID in the first place.

But I digress, thanks for the reminder on this @Corey Scott

[Mary Giblin]

remove comment

[boardtc]

@Jason, there's no need to use developer tools, you can see the sprint ID by hovering over as John Smith says. I agree it could be more easily found. Also, it should be used more, e.g. it would be great to have a url including it which allowed the backlog to open with that particular sprint expanded and ll the others collapsed.

[JinH]

Hover works on the three dots icon of the dashboard/backlog view. Hover over the icon and see the sprintID in the URL view at the bottom of the browser. Works for both future sprints and active sprints.

[David Labbadia]

Simplest, best answer.

[boardtc]

Simplest Way!

[Edison Quisiguina]

Thanks,

It works for me too.

Going to Backlog view and hover over the Three Dots

[Abe_Roba]

Mouse hover does not work

[Gabi]

As simply as that... Congratulations, @Edison Quisiguina.

[Ariel García]

Thanks. You can see the id in the botton of the page.

[Alexander Pappert]

https://community.atlassian.com/t5/Jira-questions/How-to-get-Sprint-ID-for-CSV-import/qaq-p/58364 

post #2

JIRA maintains an equivalent numeric value for each Sprint. The numeric value is what you need to have in the CSV file,

To find the numeric equivalent of a sprint, do the following : Go to Issue navigator, and specify the following query: sprint = Sprint 18.

When you finish typing Sprint 18, you will see the corresponding numeric value displayed in the query

[Alexey Popov]

1. Go to Backlog board
2. Right click on any element related to your sprint control (edit button, threee dots)
3. Inspect you sprint id in element attributes

[Kirk Franzen]

Crazy, but this is still a blocking issue for managing issues in bulk.

[Joe Ash]

When doing the bulk dates, i find having the backlog open in another tab and using devtools and selecting the sprint name is the easiest way to find out the sprint ID. So just F12 in Chrome and it's there for you in the Elements tab.

Hope that helps.

[Ankit Rathi]

Step 1 - Go to the Backlog page

Step 2 - Open Inspect element by right clicking anywhere in the page and selecting inspect (for google chrome)

Step 3 - Search for data-sprint-id in the inspect element section. Beside the entry you would find the id of the sprint in focus in UI.

[aromanov]

In Next-Gen projects I can't find data-sprint-id

[david]

sadly this is the easiest way for me to find sprint id in cloud thanks @Ankit Rathi 

[Chris Covert]

What if someone sends you a filter to run with sprint ids only

sprint in (22, 33, 44)

It returns the issues list and looking at the sprint column of the report, you can see them, but if the issue runs across multiple sprints you get multiple user friendly sprint names for a single issue, so how do you know which one correlates to 22, 33, and 44?

Basically looking for a reverse lookup from  index to friendly name

[Vicki Lea Tsang]

There's probably a better solution than this out there, but one way that works, if the sprints were added after ticket creation, is to check the History tab on the ticket. Look for where the sprints were added and it will list out the sprint names, plus their IDs (in same order as name).

[Joe Ash]

The quickest way I've come across to discover the sprint ID is to inspect the element of the sprint name when in the backlog. So just F12 when using Chrome and select the sprint name. Check out devtools and the ID is there for you.

[Marco Ocana]

Thanks Joe! This did the trick for me (ridiculous this is so convoluted)

[Tim Dowd]

Another quick way to find the Sprint ID is:

1. Do a Basic issue search for known items for "Sprint = YourSprintName"
2. Then look at the Advanced search text and it will have the "Sprint = nnnnn".

[Midhun Jose]

Go to backlog board. Find the respective sprint click on the small icon against the spirnt. You will be taken to a new screen wherer the sprint id is given in the search filed

[Deleted user]

In the Sprint View click on the icon to the right of the sprint name that produces a Query for the sprint.

The url includes the sprint number:
... ?jql=sprint %3D 117