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

[David Patrick]

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.

[Justin Leader · Accepted solution]

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.

[David Patrick]

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.

[Raspdealer]

Hey ! Still no lastSprint() function ?

[Serge M]

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. 

[Vinoth T]

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

[Joao Reis]

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

[MichaelL]

+1 agreed

[Kavya Sai]

+1 lastSprint() this saves lot of our effort

[Anna Romanovskaia]

+1 lastSprint()

[Danielle Toutoungi]

+1 lastSprint() too

[Bill Tanner]

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

[Seadna Smallwood]

+1 lastSprint() !!!

[George Pilpilidis]

+1 lastSprint() FTW!

[Manas Kulkarni]

+1 lastSprint() please please please

[Erika Fer]

+1 lastSprint()

[Valentin Miculit]

+1 lastSprint()

[Kyle Denton]

+1 lastSprint()

[Mike Nicol]

+1 for lastSprint()

[Jira Integration]

+ 1 for lastSprint()

[eli.tabrisov]

+1 for lastSprint()

[knyazeveo]

+1 for lastSprint()

[Justine Watt]

+1 for lastSprint()

[Nikhil Jain]

+1 for lastSprints()

[Jilson James]

+1 for lastSprints()

[Randy Bryant]

+1 for lastSprints()

[leonardokochake]

+1 for lastSprints()

[Annette Stierman-Verstrijden]

+1 for lastSprints()

[Andreas Joebges]

+1 for lastSprints()

[Deleted user]

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

[Bin Ji]

+1 for lastSprints()

[Deleted user]

+100 for lastSprints()!!!!

[Lien Huynh]

+ for lastSprints()

[Michelle Murray]

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. 

[Aline Figueiredo]

Please LastSprint ()

[Carl Tuetken]

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

[zhine]

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

[johannes.graessler]

+1 for lastSprints()

[Ryan Nichols]

+1 for lastSprints()

[Lorri Glover]

+1 for lastSprints()

[Vlad Calin Buzea]

+1 for lastSprints()

[John Wilkinson]

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

[Everest Hoxha]

+1 on  lastSprint() or previousSprint()

[Jenny Pittman]

EVERYONE!!! There's an open feature request for this here. Please go vote! 

https://jira.atlassian.com/browse/JSWSERVER-12432?_ga=2.221582360.1072606985.1595434356-820643670.1587144901&error=login_required&error_description=Login+required&state=ebda5ad0-3491-4a77-bd28-ffb72318a94e

[Daniel Rodriguez]

And one for cloud https://jira.atlassian.com/browse/JRACLOUD-79678

[Gary.Samuelson]

...

[LIndsay Kiefer]

+1 lastSprint() would be sooooooo helpful!

[Kirk J Gould]

Try This:

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

[Mike Nicol]

Doesn't work for me.

[Aakash Chauhan]

.

[Maria Akulova]

doesn't work for me

[John Mimms]

does not work

[leyna_rottboll]

Just use subtract weeks from current date https://community.atlassian.com/t5/Jira-questions/JQL-for-tickets-closed-within-a-time-range/qaq-p/348531