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?