Create
cancel
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

JQL for Last Sprint

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.

3 answers

1 accepted

4 votes
Answer accepted

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

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

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

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

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

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

Suggest an answer

Log in or Sign up to answer
TAGS

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