Why in the filter, "ORDER BY Sprint ASC" is not working at all

Question

Original of my need is to find all tasks even closed and sort as the order in backlog (sprint by sprint)

In my created filter, I try to fetch all tasks firstly order by sprint. but the order by condition seems not working at all. it always random, not sort by sprint id or sprint name!

The whole JQL is "project = CBW AND ORDER BY Sprint ASC, priority DESC, key ASC", any idea or suggestion for my JQL??

david.gao · Answer

in my filter query result the sprint order is like following which seems not correct:

CBW 2.0 sprint 3 19.10.21
CBW 2.0 sprint 4 19.11.08
CBW 3.0 sprint 1 19.12.06
CBW 3.0 sprint 2 19.12.26
CBW 2.0 sprint 1 19.09.26
CBW 2.0 sprint 2 19.10.09
CBW 3.0 sprint 3 20.01.16
CBW 3.0 sprint 4 20.02.07
CBW 5.0 sprint 1 20.06.30
CBW 5.0 TBD
CBW 4.0 sprint 1 20.03.03
CBW 4.0 sprint 2 20.03.31
CBW 4.0 sprint 3 20.04.29
CBW 4.0 sprint 4 20.05.28

further, columns in filter result are:

Issue Type, Key, Summary, Status, Updated, Story point estimate, Sprint, Description

Thomas Magny-Garcia · Answer

Hi @david.gao

In my project, it seems working. Order by filters first the sprint (by ID I guess), then the priority and finally the key...
So, for instance, I have :
CBW - 1 | High Priority | Sprint 1

CBW - 19 | Medium Priority | Sprint 1

CBW - 78 | Medium Priority | Sprint 1

CBW - 15 | Medium Priority | Sprint 2

CBW - 20 | Medium Priority | Sprint 2

CBW - 11 | Medium Priority | Sprint 3

May you provide a screenshot with the search query and the columns to help you ?

Hope it helps !