How can Closed Dates of bugs be tracked in bulk?

Question

So we have a Metrics in place in our project to showcase the defect ageing where we track the difference between the Created Date and the Closed Date. However, since there is no field for Close Date, we have to check every closed issue and manually note down the Closed Dates. It would be great if we could somehow directly access the Closed Dates instead of finding out from the history of the issues.

Mehmet A _Bloompeak_ · Answer

Hi @Sayan Ghosh Dastidar ,

You can use Status Time add-on. It displays the status entrance date of issues in bulk.

If you are looking for a free solution, you can try Status Time Free.

Zoryana Bohutska _SaaSJet_ · Answer

Hi @Sayan Ghosh Dastidar

Also, you can try the free trial version of solution Time Between Statuses (cloud & server) which will help you automatically get time from one status to others. Moreover, you will be able to set statuses to pause the timer.

Hope it helps

Ste Wright · Answer

Hi @Sayan Ghosh Dastidar

Choose one of your statuses to be set via Resolved Date. In this instance, I'd use resolutions for Closed - it's the absolute date of completion rather than Resolved. Retest is after Resolved where work is technically continuing.

You could use Automation for the second field. Below I've used Resolved to be set by another field - but this works for either status.

You'll need to be a Jira Admin to create the field. Then...

* Go to Settings (via the cog icon in either bottom-left or top-right)
* Select Issues - then from the left-hand menu, select Custom Fields
* Press the "Create custom field" blue button
* Select to create a date picker or date time picker and press Next
* Give the field a name (eg. Fix Date) and press Create
* Add the field to a screen if needed

^ Remember, if you add the field to a screen it would be editable by users. I would create it and then keep it hidden from screens - making it harder for a user to modify.

Next you need to create an automation rule. You need to either be a Project Admin for a project-specific rule - or a Jira Admin for a global rule.

As a Project Admin...

* Go to Project Settings > Automation (from left-hand menu)
* Press the Create Rule blue button in the top-right corner
* Choose the Trigger "Issue transitioned". Set "To Status" to Resolved
* Select the Action "Edit issue fields". Set your new date field to populate - in the text box, put {{now}}
* Give your rule a name and enable it.

^ Now each time an issue is transitioned to resolve, this field will update with the current date or date/time, depending on which type of field you chose to create.

You can access global rules from the project screen - just press the "Global administration" hyperlink. Or you can get to them via settings - go to Settings > System > Automation Rules

With this you could compare Resolved Date, Fix Date and Created Date :)

Ste