If you sprints had a definite time interval (e.g. 2 weeks) and you know this interval, then you can write your jql using the created date variable. Something like:
project = myProject AND issuetype = bug AND (created >= sprintStartedDate and created <= sprintEndDate)
Of course the above JQL will work only if the sprints have the same time interval. If they have a different time interval, then you can simply add an OR statement with the additional time interval.
Hope that helps!
Thanks Alex. Will try this. But I was looking for something which I dont have to change every sprint. so that then i can add a Rich filter pie chart to this jql query.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
If your business need is e.g. to find all bugs from all closed sprints, then there is a solution for you.
project = DSP AND sprint in closedsprints() order by created DESC
If your need is to find all bugs from two specific sprints then you could use as well:
project = DSP AND Sprint in (2, 3) order by created DESC
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Yes, and...to Alex's suggestions:
When you need something specific like this (the last 2 sprints) and you do not want to change the filters manually, you have a limited number of options:
Kind regards,
Bill
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Use automation for Jira rules to dynamically alter the filter when a sprint completes. Please note you will need to learn about automation rules and calling the REST API to do this one.
Nice thought @Bill Sheboy! I wasn't aware that you could do that, and I might give it a try!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hey @Sanket Salvi ,
I don't think it's currently possible.
You can get the results manually by getting all the bugs in the previous 2 sprint and checkng the creation time.
What do you need the results for?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
I want to sort the bugs resolved in last 2 sprints to analyze the RCA (Universal)
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.