How to search issues from specific Sprint


we use jira + GH (new Scrum Boards).

How do I search for issue (in jira) for all issues under a specific Sprint?



6 answers

1 accepted

This widget could not be displayed.

Hi Janiv,

to find issues from a specific sprint, you have to add one of the following to your JQL query:

sprint = ID
For this you have to know the ID (not name) of your sprint.
In order to find the Sprint ID you could either view an issue of that sprint in XML view (where all fields are displayed, SRINTID is just a hidden field) or hoover (not click) your mouse over the displayed sprint in the view issue screen, section "Agile", Value "Active Sprint".

Thanks, how do I know the sprint number?

as pointed out above. I edited the post to highlight possible ways.

Thanks and sorry (I did not notice the edit as I read from the mail notification),


you're welcome, allways glad to help :)

See Bills answer for an easy general way of discovering sprintid.

This widget could not be displayed.

You can always find issues in the current sprint by using the dynamic value "sprint in openSprints() " or find previous sprints with "sprint in closedSprints()" Use a "project in (....)" based on the filter used for your scrum board to get the perfect match. (I suggest just modifying the filter used for the scrum baord, adding the "sprint in openSprints()" and saving as a new filter.

sprint in openSprints()

To find issues in a particular sprint that is not active, just view the sprint report and follow the link "view <SPRINT FOO> in Issue Navigator"


If I want to use the method "closedSprint()" but I want to see the last 3 closedSprints can I use closedSprints(-3) ?

This widget could not be displayed.

Another way is to start typing. The drop down will show the title. Choose one and the correct sprintid is inserted...


This would make a nice confluence macro (or enhancement).

Thank you for this! The other ways of discovering sprintid are just plain silly compared to this.

This widget could not be displayed.

It appears that there's a bug that now "Sprint in (opensprints()) isn't working? I'm using JIRA 5.1.1 and GH

This widget could not be displayed.

I understand your frustration, but this is not an answer. Please comment on the original question or answer instead.

Make sure you are using proper case for the function openSprints()

This widget could not be displayed.

What Eddie says is partially right and very relevant, given the recommendation to use the openSprints() function in the answer. There is an existing bug related to the openSprints function throwing an error for non-admin users.

Suggest an answer

Log in or Sign up to answer
Atlassian Summit 2018

Meet the community IRL

Atlassian Summit is an excellent opportunity for in-person support, training, and networking.

Learn more
Community showcase
Posted Aug 06, 2018 in Jira Service Desk

A is for Activate: Share your top Jira Service Desk onboarding tips for new users!

Hi, everyone! Molly here from the Jira Service Desk Product Marketing Team :).  In the spirit of this month's  august-challenge, we're sourcing stories of Jira Service Desk activation fro...

576 views 25 15
Join discussion

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you