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" ........)
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.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
thanks
the problem is that I need to use the operator "OR" to not have repeated tickets (duplicated line in excel)
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
How is this post shown with "ACCEPTED" Answers.
The answer is a non-answer.
Cannot be DONE...is not "Answered"
"Answered" = Solution(s) is/are available.
"Responded to" = Responses have been given, some of which surface that is/is not possible to have a direct/indirect solution.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.