I'm trying to create a filter to order my issues per sprint, to see the one that have been the most postponed from 1 sprint to another. What I've been able to achieve yet is:
issuetype in (Bug, Task) AND status in (Open, "In Progress", Reopened, Resolved) and Sprint is not EMPTY and Sprint in openSprints()
The recent issues only have 1 sprint. My latests issues can have been postponed 3, 4, 5 times and have up to 5 sprint IDs
What I'm trying to get is either to order by sprint ID (ASC) either to order by the one that has the most sprint IDs. Something like this:
issuetype in (Bug, Task) AND status in (Open, "In Progress", Reopened, Resolved) and Sprint is not EMPTY and Sprint in openSprints() ORDER BY sprint ID ASC
issuetype in (Bug, Task) AND status in (Open, "In Progress", Reopened, Resolved) and Sprint is not EMPTY and Sprint in openSprints() ORDER BY Count(sprint)
Any idea ?
Can't you just order them by created date and see which one are the oldest and still not solved?
Be aware that in Jira Agile, an issue can only be part of one sprint so you'll need to keep the old sprint id's in a custom field if you want to do it like that.
Thanks for your answer, but ufortunately that's not acceptable solution for me yet. I have some issues in my backlog created long time ago, then planned for 1 particular sprint (for example sprint with ID = 5), then due to delays, I have to postpone this issue to sprint 6, then 7
On the other hand I can have another issue, created at the same date, but initially planned for sprint 7. When I arrive on sprint 7, this one is not late. If I have to postpone on sprint 8, it becomes late, but less than the one initially planned on sprint 5
Hope it clarifies
I was looking for an answer as well, and found one by accident, so I thought I'd share for future searchers: ORDER BY Rank DESC, since the ones ranked higher will be in the sooner sprints, and the ones ranked lower will be in the later sprints (then backlog lower still).
I’m a designer on the Jira team. For a long time, I’ve fielded questions from other designers about how they should be using Jira Software with their design team. I’ve also heard feedback from other ...
Connect with like-minded Atlassian users at free events near you!Find a group
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no AUG chapters near you at the moment.Start an AUG
You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs