JIRA Filter by sprint order by sprint ID

Hi

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

or

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 ?

3 answers

1 accepted

This widget could not be displayed.

Hi Yoann,

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.

Just wondering.

Best regards,

Peter

This widget could not be displayed.

Hi Peter,

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

This widget could not be displayed.

I need this too, I guess the issue is that we can name a sprint anything. Surely it has an internal label thats not 'Monkey works sprint 44' more a ref code. 

Some really logical features are frustratingly missed. 

Suggest an answer

Log in or Sign up to answer
Atlassian Summit 2018

Meet the community IRL

Atlassian Summit is an excellent opportunity for in-person support, training, and networking.

Learn more
Community showcase
Posted Aug 06, 2018 in Jira Service Desk

A is for Activate: Share your top Jira Service Desk onboarding tips for new users!

Hi, everyone! Molly here from the Jira Service Desk Product Marketing Team :).  In the spirit of this month's  august-challenge, we're sourcing stories of Jira Service Desk activation fro...

575 views 25 15
Join discussion

Atlassian User Groups

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!

Find my local user group

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

Groups near you