How to use JQL to find time a defect is open to closed?

Question

Hello!

I am trying to find the velocity of a team when given the number of developers available for bug fixing by only using JQL (Having trouble implementing plugins as of right now).

Specifically, I am looking for the number of days measured for the duration between the time the defect is changed from Open to “In Progress” and the time the defect is changed from “In Progress” to “Ready For Testing”.

Thanks again for your time!

Amrita Nair · Answer

Hi,

Although I cannot think of a query that would return an average number of days the issue spends in different stauses, the following should help you prepare some stats:

1. project = XXX AND status changed from Open to "In Progress" after -3d

(this JQL will return the number of issues that were moved to in progress after 3 days of being in Open status. This can be replaced by -1w for 1 week & -1m for 1 month and so on)

2. project = XXX AND status changed from "In Progress"  to "Blocked" during (2018-06-01, 2018-07-16)

(this JQL will return the number of issues moved from status between given dates)

I generally  use the control chart and that helps a great deal. The JQL can be tricky and not a 100% reliable source of information since the query might exclude/miscalculate any conditions where the records were moved back to in progress from testing (if there are reworks)

You can apply filters in the control chart and calculate the cycle time & lead ime to fetch the velocity of the team.

Hope this helps.

Cheers,

Amrita

Tuncay Senturk _Snapbytes_ · Answer

Hello Jackie,

There is no such bundled feature. There are two solutions:

* Open date is the created field. Create a date field which will hold the In progress date. And set the current time via post function. Then you can export issues in issue navigator including created and In Progress Date
* You can use Enhancer Plugin's Time Between custom field. With this custom field, you can display, search time between two statuses (or events) using your working calendar.

Hope it helps

Alexey Matveev · Answer

Hello,

JQL only returns issues. It can not return number of days. You would need a plugin like EasyBi to get this info.