nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

JIRA Filter by sprint??

Tudor Hofnar

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

Accepted answers

Jamie

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.

All comments

Dave

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

Tudor Hofnar

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!

Dave

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.

Jamie

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.

Tudor Hofnar

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?

brettveen

I found this Knowledge Doc helpful: https://confluence.atlassian.com/x/UQTfFw

rhartzell

Just what I was looking for. Thank you.

Shawn Beeson2

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

Sjaak Overgaauw

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

Administrator156

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.

edgar lopez1

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

Miguel Angel Salas Solis

Hi, is there a way to filter tasks that a month ago were not assigned to a sprint?

For instance, I have 20 tasks that currently are assigned to a sprint, some of them to Sprint 1 and others to Sprint 2, but I want to know which of them were unassigned a month ago... is that possible?

Apparently "Sprint was EMPTY after date1 before date2" is not an option.

Thanks

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

cloud

jira-cloud