How to sort by Sprint ASC by first non-completed sprint (if any) or last completed sprint (if all co

[barnabas_makkay]

I'm having an issue in JQL where I'd like my filtered results to be sorted by Sprint. Some issues got carried over from previous sprints and have completed sprints on them. Sorting by Sprint ASC seems to take into account previous completed sprints as well, which makes my sorting not work. I believe that this is not how it's meant to work as in many views the completed sprints are tucked away under a +N button. For tracking it might be good to keep previous sprints perhaps, but more importantly when sorting I need a way to sort by the first active/upcoming sprint or last completed sprint. 

How could I specify this in JQL?

[Marc -Devoteam- · Accepted solution]

Hi @barnabas_makkay 

Welcome to the community.

This is currently not possible, see this Bug; JRACLOUD-81425 

[barnabas_makkay]

Cheers. 

[Stephen_Lugton]

Hi @barnabas_makkay 

As @Marc -Devoteam- says this is not currently possible, however there are workarounds that you could use with future work items using a custom field and automation.

Firstly create a short text field 'YourSprintFieldName' e.g. 'Parent Sprint' or similar. (I only used this name as we have an existing field with that name)

Next create an automation, e.g.:

Going forwards any sprint changes will be reflected in this field and you can sort on this field.

In addition, you could add the following to your JQL to only show work items in the current or future sprints:

Sprint in (openSprints(), futureSprints())

or for completed sprints only:

Sprint in (closedSprints())

[barnabas_makkay]

Thanks, I'll look into it.