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

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

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

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
How to earn badges on the Atlassian Community

How to earn badges on the Atlassian Community

Badges are a great way to show off community activity, whether you’re a newbie or a Champion.

Learn more
Community showcase
Published Monday in Jira Software

How large do you think Jira Software can grow?

Hi Atlassian Community! My name is Shana, and I’m on the Jira Software team. One of the many reasons this Community exists is to connect you to others on similar product journeys or with comparabl...

713 views 6 13
Read article

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