Jira filter for a list of sprints Edited

[Bilal_a bilal_aa]

Hello,  please I need a help for task to prepare a filter that shows the tickets of sprints from sprint 1 to  10 without using all the numbers 1,2, ...10 , I need a generic method if possible to use only 1 and 10  ( like: show from 1 to 10 )

Untill now I have this but it uses all the numbers, it is not usefull :
project = SWTAM AND (Sprint = "STAMBD-Sprint 1" OR Sprint = "STAMBD-Sprint 2" OR Sprint = "STAMBD-Sprint 3" ........)

[Sudarshan TS · Accepted solution]

Hello @Bilal_a bilal_aa  Welcome to the community,

Firstly - JQL does not support looping statements (like if, else, switch)
so, your method of (n-1) will not work here.
JQL is a simple data extracting query language.

Why not try to query all the items in your project and then export the to excel , filter them sprint wise and then you will have what you need.
(but you will have to do some export and excel data correction stuff)

But i understand you will have to do this as a manual activity on a regular reporting basis.

[Kagithala Babu Anvesh]

project = SWTAM AND sprint in( sprint 1, sprint 2,sprint 3,sprint 4,sprint 5,sprint 6,sprint 7)

or if you have only these 10 sprints in your project 

and some sprints are closed , one is active and few are future then try this below

project = SWTAM AND Sprint in (futureSprints(),closedSprints(),openSprints()) 

Try and let us know

[Bilal_a bilal_aa]

thanks 
the problem is that I need to use the operator "OR" to not have repeated tickets (duplicated line in excel)

[Jack]

If you want to see all issues that have a sprint  associated then use ... AND sprint is not empty. However if you want specific sprint you must list each sprint you wish. You cannot specify a range. 

[Bilal_a bilal_aa]

thanks ( I want a range but it seems it is not possible )