Exclude project sprints in a jql filter

Question

Hello everyone, I would like to know if it is possible via a JQL filter to exclude the current and future sprints of a particular project from the list of projects in my JQL?

Here is the filter:

project IN (TSN, TG, SR, SAD, CYB, AP, SEES, SIA,EDT,OC,SEDF,SEUES,SFRG) and (Sprint != 2265) and (Sprint != 2287) and status != Completed ORDER BY Rank ASC

I'd like to exclude current and future sprints from the "CYB" project, because the sprints are coming up on my board and getting mixed up.

So far I've managed to exclude the 2 sprints manually with : "and (Sprint != 2265) and (Sprint != 2287)", I'd like to know if it's possible to exclude them automatically? without typing each sprint by hand each time a new one is created.

Thank you very much for your help :)

JM Perrot · Answer

Hello @Wakil BENAMOUR ,

As @Mikael Sandberg mentioned, you have JQL functions to perform this operation.

You also have "closedSprints()":

sprint in closedSprints()

This function includes tickets only in, as you guessed, closed sprints.

You can find more information in the documentation:

* Common JQL queries for sprints in Jira Cloud 
* JQL functions

Mikael Sandberg · Answer

You can exclude current (open) sprints and future sprints by using these two functions in your JQL:

sprint not in openSprints() AND sprint not in futureSprints()