Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

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.

6 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 # people like 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

+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()

+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.

+1 for lastSprints()

+100 for lastSprints()!!!!

+ for lastSprints()

How is it 5 years later and lastSprints() isn't here yet...... +1. and also going to vote on that feature request. Sprint reporting would be so much easier with it. 

Please LastSprint ()

Agreed, this is a function needed to manage sprints and to track work.

+1 for LastSprint() as being very valuable. Thank you!

+1 for lastSprints()

+1 for lastSprints()

+1 for lastSprints()

+1 for lastSprints()

We need a lastSprint() or previousSprint() type function.

+1 on  lastSprint() or previousSprint()

Try This:

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

Doesn't work for me.

doesn't work for me

Like Ryan Nichols likes this

does not work

+1 lastSprint() would be sooooooo helpful!

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