Query for open sprints but excludes very next sprint to become active

Question

I am tyring to write a query that includes the work in open sprints, but excludes the work assigned to the very next sprint to become active.

This is the feedback I keep getting in research shows me this query, but the results returns the next sprint to become active:

project = "myproject" AND sprint in futureSprints() and sprint not in closedSprints()

Karri Adkins_3xtwwg · Answer

To clarify further.  A team that plans two sprints ahead.  With that you have:

* An "active" sprint (work assigned to a sprint that has started and not yet ended),
* Then 1, 2 or 3 sprints of planned work (sprints that have not yet started).

One of those sprints however, is the next sprint to start.

I need a query that identifies the work in all those sprints except the "active" sprint, and the sprint next to start without having to continuosly alter it in some way.

Walter Buggenhout · Answer

Hi @Karri Adkins,

If you want the issues in currently active sprints, you would need the following:

project = MyProject AND sprint in openSprints()

Just that. Sprint in futureSprints() does exactly what you say you don't want in the result: issues assigned to sprints that have not started yet.

Hope this helps!