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

[Karri Adkins]

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

[Walter Buggenhout]

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!

[Karri Adkins]

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.