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

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.

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!

Thanks,

-dave

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?

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
Atlassian Community Anniversary

Happy Anniversary, Atlassian Community!

This community is celebrating its one-year anniversary and Atlassian co-founder Mike Cannon-Brookes has all the feels.

Read more
Community showcase
Julia Dillon
Posted Tuesday in Jira

Tell us how your team runs on Jira!

Hey Atlassian Community! Today we are launching a bunch of customer stories about the amazing work teams, like Dropbox and Twilio, are doing with Jira. You can check out the stories here. The thi...

503 views 1 18
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