JQL - Filter Tickets by Sprints in "Active Sprints"

[Caroline CHIALE]

Hi,

I would like to know if it's possible to order the tickets within the Active Sprints view by sprints? 

I tried to use a JQL query but it doesn't work...

Thanks in advance :)

[Brittany Wispell · Accepted solution]

Hey @Caroline CHIALE

What was the JQL query that you tired? 

I believe this JQL query might work for your case. Here, we have openSprints() which means any active sprints and the ORDER BY is ordering the sprints in ascending order. You can also add the "Sprint" field as a column for visuals. 

Sprint in openSprints() ORDER BY cf[10020] ASC

 

Hopefully this helps! 

-Brittany

[Caroline CHIALE]

Hi @Brittany Wispell, 

Thanks for your quick response!

Sorry, it was not very clear in my first message but I would like to know if it's possible to display the tickets in the Active Sprints view group by Sprints (by adding a JQL query to group the tickets by sprint in the swimlanes and display all the sprints). 

It would be easier for us. 

Thanks in advance! 

[Brittany Wispell]

Hey @Caroline CHIALE

I believe you would need to create a swimlane for each Sprint and update the swimlane JQL when you have new active sprints. 

Are you looking for something like the below? 

Swimlanes showing both active sprints. 

The swimlane queries

These are static numbers for the current sprints, once you have more you'll need to update the name/number of the sprint in each swimlane and their Name if you would like for it to match up to the sprint name. 

I hope this helps!

Please let me know if you have further questions. 

-Brittany