JIRA Filter by sprint??

How can I create a filter to show all issues which were finished in a particualar GH sprint?

For example, I want all issues for project x in sprint 18 by assignee? I tried this but I don't get only sprint 18....any ideas?

project = X AND assignee = user1 and Sprint = 18 ORDER BY Rank

5 answers

1 accepted

18 votes
Accepted answer

I know this question is a little old, but incase anyone comes across this via Google (like me). The solution to get issues in the "current" sprint(s) is as follows:

project = X AND Sprint in openSprints()

I'm not sure when the openSprints() function was made available, but this definitely works with the current version of Greenhopper.

Cool! This will definitely help us out, have you come across any way to display all issues in a previous sprint or are we still limited as menitoned in the other answer?

Just what I was looking for. Thank you.

1 vote

Hi Tudor,

Is that the sprint name or the sprint ID (even though your sprint may be called Sprint 18, it is referenced by a numerical id in the DB)? If you hover over a link to that sprint, you should see the sprint ID in the URL and can use that in your JQL. Let us know if that works for you!



is there any way to rather than set it to a specific sprint, set it to the current sprint running in GH? I can't seem to find the sprint ID and would really like it to show based on the current sprint. Basically I need a chart/report to show a user how many hours are remaining for the current sprint, on the issues that are assigned to them. Is there an easier way that what I am doing? I am using an issues statistics report with the filter as mentioned in my previous post and showing the time remaining field on the report. Thanks for the help!

Sorry for tagging on to this, but what if I want everything that is NOT in a Sprint....I want a "Planning Board" that shows all backlog items that have not been assigned a sprint value

This is exactly what I was looking for. Is there a workaround for this or is it simply not possible

Well for such a case this works well: project = <yourprojectname> and Sprint is EMPTY We use this to keep a check on all backlog items. Hope this helps.

Does the buiilt-in backlog not do this for you?

0 votes

Because the concept of a current sprint only exists inside the view of that board (and you can even run parallel sprints on one board), there isn't a way to filter based on this. Unless a particular report on the board is a better choice, it sounds like you are already getting all the information that you can.

Suggest an answer

Log in or Sign up to answer
Community showcase
Published Nov 27, 2018 in Portfolio for Jira

Introducing a new planning experience in Portfolio for Jira (Server/DC)

In the past, Portfolio for Jira required a high degree of detail–foresight that was unrealistic for many businesses to   have–in   order to produce a reliable long-term roadmap. We're tur...

2,711 views 17 21
Read article

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