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.
Hi @Heiner,
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,
Best,
Hannes
Hi @Heiner
Try this please :
status = 'DONE' AND Sprint is not EMPTY ORDER BY Sprint DESC, updated DESC
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.