JQL for Last Sprint

[Shawn Garner]

I'm looking to see if there is a way to constantly query on the last sprint so that I could put it in a dashboard with some of the gadgets.

[Tayyab Bashir · Accepted solution]

Hi,

There is currently no way to just get the stories/issues from recently closed or last sprint. 
Since there is no JQL function such as sprint in lastSprint(), so you'd have to manually change the JQL filter each time.

There's an open request for this feature, you can also vote on it: https://jira.atlassian.com/browse/JSWSERVER-12432

[Kathy Dahmen]

Hello ... Does anyone know if there is an equivalent issue for CLOUD Jira?

[Deleted user]

can you help to find the issues of current month based on shift wise(6am to 3pm).???

[Aline Chapman]

I would vote for this as well for Cloud, I need a filter for previous sprint and can't get to it.

[Shirley]

You can add this to your JQL query, where the resolved days is the length of your sprint (in this case, 14 days for a 2-week sprint), to limit the results to the recently closed sprint:

Sprint in closedSprints() AND resolved >= -14d

[Daniel Rodriguez]

Actually they have a ticket for this https://jira.atlassian.com/browse/JRACLOUD-79678

[Dave F]

While not always providing perfect results for the recently closed sprint, the following may help. Where this can fail is if issues were closed during the sprint timeframe that were not in the sprint (e.g. in a clean-up of old issues)

https://community.atlassian.com/t5/Jira-Software-questions/Is-there-any-way-to-filter-by-the-last-3-closed-sprints/qaq-p/983771

[Paulo Meirelles]

Hi,I had the same issue, a lot of queries to Dashboards needing last Sprint, then once there is no way without programing, I created a program in Python that can access Jira and change the Sprint to another new Sprint on filters.

 

Tre process just seek Filters that has the condition "Sprint in ({Selected Sprint])" and changes to "Sprint in ({New Sprint]).

I can share this module if you want.