It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Show a list of issues from the previous Sprint using JIRA Issue Filters

As a Scrum Master,

I want to be able to identify the User Stories completed in the last completed Sprint using the JIRA Issue Filter either with JQL Syntax or some other technique,

So that Senior Management can be presented with a single confluence page giving an overview of work completed by my team.

More info:

The page is a three column format with embedded JIRA Issue queries.

Column 1 is the 'Past Stories' - as requested above

Column 2 is the current Sprint - achieved using the sprint = openSprints() query

Column 3 is Future Sprints - we have a 'Potential Candidates' sprint that is never started, but helps us to identify those stories from the backlog that are meeting our Definition of Ready.

4 answers

1 accepted

1 vote
Answer accepted
David, I'm sorry, I don't believe there is a lastSprint() type function at this time. You'd have to manually change the filter each sprint.

Thanks for the quick reply.

I've had a few guys looking at it here, and the closest we could come up with is a list of completed stories by completion date using the following:

project = Goose and sprint in closedSprints() and status = closed order by updatedDate DESC

Its then a bit of digging to get the sprint number from that.

I think I need to adjust my approach and get a bit more clarity on exactly what is wanted in the report, as actually, just letting people loose with the Sprint Report might be all that is required.

Like # people like this

Hey ! Still no lastSprint() function ?

Like Abhishek Joshi likes this

Thanks, David Patrick your solution was the closest, and "sprint in closedSprints()" does the trick well, or it can be refined to the specific sprint ID, in case one needs only the last sprint to consider. 

+1 to LastSprint() and can we get this feature asap?

Like # people like this

+1 for that! Can;t believe Atlassian did not make this available yet. Should be the easiest thing for them, and definitely one of the most important functions for automating sprint reports.

+1 lastSprint() this saves lot of our effort

Like # people like this
Like MichaelL likes this

+1 lastSprint() too

+1 lastSprint()  Just had this request today from a project team

Like colleen.johnson likes this

+1 lastSprint() !!!

Like Jennifer_Collins likes this

+1 lastSprint() FTW!

Like Sean Sowell likes this

+1 lastSprint() please please please

Erika_Fer I'm New Here Dec 27, 2019

+1 lastSprint()

+1 lastSprint()

+1 for lastSprint()

+ 1 for lastSprint()

+1 for lastSprint()

+1 for lastSprint()

+1 for lastSprint()

+1 for lastSprints()

+1 for lastSprints()

Like grsham.gohil likes this

+1 for lastSprints()

+1 for lastSprints()

+1 for lastSprints()

+1 for lastSprints()

+1 for lastSprints()

This needs to specify which sprint. For example I want to see only last sprint OR last 2 sprints OR second to last sprint. All of these need to be possible.

Try This:

project = "Test" and sprint in openSprints(-1)

Doesn't work for me.

Suggest an answer

Log in or Sign up to answer

Community Events

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

Find an event

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

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you