Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
4,296,047
Community Members
 
Community Events
165
Community Groups

JQL - Filter Tickets by Sprints in "Active Sprints"

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 :)

1 answer

1 accepted

1 vote
Answer accepted

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

Screen Shot 2022-06-22 at 11.24.04 AM.png 

Hopefully this helps! 

-Brittany

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! 

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. Screen Shot 2022-06-24 at 8.29.07 AM.png

The swimlane queriesScreen Shot 2022-06-24 at 8.29.22 AM.png

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

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
STANDARD
PERMISSIONS LEVEL
Site Admin
TAGS
Community showcase
Published in Jira Software

Upcoming changes to epic fields in company-managed projects

👋 Hi there Jira Community! A few months ago we shared with you plans around renaming epics in your company-managed projects. As part of these changes, we highlighted upcoming changes to epics on...

14,515 views 37 44
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you