JQL to filter Bugs created and resolved in same Sprint

[govinda agarwal]

Hi,

I am trying to build JQL query to filter bugs created and resolved in same Sprint. My project is long running over an year with 2 weeks sprint. The goal here is to see how many defects were created in the Sprint and resolve in the same sprint.

Other scenario: It could include the defects that are in the backlog and pulled in a sprint and resolved in the same sprint.

Appreciate quick ideas on this as this is urgent requirement for my project. 

[Jack Brickey]

For this you are going to need to go beyond the capabilities of JQL. You could use and addon like Scriptrunner which will allow you to compare dates or you could export to CSV and use Excel. Basically you need something like

Resolved date <= sprint end date AND created date >= sprint start date

what might be of interest in excel is to do the following

• create a column “created in sprint” which provides the sprint name that each bug was created in - created date >= sprint start and created date < sprint end date
• create a column “Resolved in sprint” which provides the sprint name that each bug is resolved in
• create a column “resolved in same sprint” and just compare the two

this will allow you to then create charts to illustrate the effectiveness of closing bugs within the same sprint.

finally, I would recommend scouring the Marketplace for other addons as there are likely some that would effectively meet your needs.

[govinda agarwal]

Thank you Jack.

This may helpful workaround. I have like 30 sprints, so I have to specify each ones of the start and end dates in order to achieve this in excel. 

[govinda agarwal]

I was wondering if there is any Jira out of the box function that provide this capability. Example project = "ABC" AND issueType = bug AND sprintCreated = sprintResolved

Is there a function like sprintCreated where sprintCreated would also be when bugs were assigned to Sprint if they were put in backlog when originally created.