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

Earn badges and make progress

You're on your way to the next level! Join the Kudos program to earn points and save your progress.

Deleted user Avatar
Deleted user

Level 1: Seed

25 / 150 points

Next: Root


1 badge earned


Participate in fun challenges

Challenges come and go, but your rewards stay with you. Do more to earn more!


Gift kudos to your peers

What goes around comes around! Share the love by gifting kudos to your peers.


Rise up in the ranks

Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!


Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
Community Members
Community Events
Community Groups

How to order a query by last active sprint

I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
Mar 29, 2023

I have a filter/query showing a list of all issues in status done ordered by sprint.

But some issues are assigned to more than one sprint and then the first assigned sprint is used for sorting. But I want to order by the last assigned sprint.

My query:

status = 'DONE' AND Sprint is not EMPTY order by Sprint DESC

Ordering by "Updated" does not work as sometimes old issues are updated.

Result: Issues completed in Sprint 70 are mixed with issues completed in Sprint 69.




2 answers

0 votes
Hannes Obweger - JXL for Jira
Marketplace Partner
Marketplace Partners provide apps and integrations available on the Atlassian Marketplace that extend the power of Atlassian products.
Mar 29, 2023

Hi @heinersuter,

welcome to the community!

Have a look at this question: Put simply, you'll need to get ahold of an issue's last sprint. To do so, you could either use Jira Automation to extract the last sprint and write it to a separate custom field, or consider a solution from the Atlassian Marketplace; e.g., this would be easy to do using the app that my team and I are working on, JXL for Jira:


Hope this helps,



0 votes
Oday Rafeh
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
Mar 29, 2023

Hi @heinersuter

Try this please : 

status = 'DONE' AND Sprint is not EMPTY ORDER BY Sprint DESC, updated DESC
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
Mar 29, 2023 • edited

As mentioned in the question, I cannot order by Updated as old issues are sometimes updated.
The result list is better ordered that way. But not perfectly ordered.
An issue started in Sprint 20 and completed in Sprint 70 in the above example will never show up on top of the list.

Suggest an answer

Log in or Sign up to answer
AUG Leaders

Atlassian Community Events