How can I create a Filter than can show all the Active Sprints from a Project

[Stefan Mitu]

Right now it shows all active sprints and also closed sprints that also had the task. 

Ex: is sprint 1 had task 1 and the sprint was closed and task 1 was moved in sprint 2 - it will show both sprints in the list even if Sprint 1 is now closed, and Sprint 2 is active.

Thank you in advance.

[Jack Brickey · Accepted solution]

Hi @Stefan Mitu , you can query for "issues" in active sprints using the following JQL.

project = abc and sprint in opensprints()

[Stefan Mitu]

hello there. As i mentioned in the description: it shows also closed sprints that had the issue at one point.

[Jack Brickey]

Hi @Stefan Mitu , so what I offered will show only issues in open sprints. If an issue was in a previous sprint but incomplete and rolled into a future sprint that is now active that issue is included. If you are asking for those issues that are in an ope sprint but exclude any issue that were in now closed sprints then try the following.

project = abc and sprint in opensprints() And sprint not in closedsprints()

[Stefan Mitu]

@Jack Brickey That worked. Thank you very much!

[Prachi Bolar]

Hi @Stefan Mitu ,

Welcome to Community,

We had an issue yesterday where the details from old sprints where also visible. It should be resolved now.

The below queries should help you

1. Create a filter using the following JQL and save it.  The query will get all issues that are in an open Sprint:
   sprint in openSprints() ORDER BY Rank

project = JRA AND sprint in openSprints() will give you all issues that are associated with the current active sprint.

Thank you,

Prachi

[Stefan Mitu]

Thank you!