How can I extract the time at which a set of issues went through a specific state ?

[Laurent T.]

Hi,

I'm looking for a way to extract some data from an issue's history automatically or through a dashboard. I'm using Jira on the cloud and my goal is to get the date my issue went through the "done" resolution state before moving to the "fixed" one or get the date my issue went through a specific status before moving to another one.

I'd like to avoid having to go through each issue and manually extract this from the history.

Is there any way to do that ?

[Zoryana Bohutska _SaaSJet_]

Hi @Laurent T. ,

I'd like to propose the solution - the add-on Issue History for Jira Cloud (link).

It shows the history of all changes that had been made with specific issues.

Plug-in allows:
- Get the changes log ordered by the date.
- Use filters to select issues list.
- Set columns to show different fields on the report grid.
- Apply custom date range to filter results.

At the Atlassian Marketplace you can get more information about the add-on and try the trial version of it.

If you have any question, please contact me directly zoryana@saasjet.com.

[Earl McCutcheon]

Hello Laurent,

First to make sure I understand the setup, you're noting that the workflow is "some status >> Done >> Fixed" with the resolution is getting set when entering the Done status, Not when entering the Fixed status coming from Done,  But you want to be able to track the timestamp of done to Fixed Transition as you cannot rely on the Resolution date because it was set at the earlier status change.  Let me know if I misinterpreted the question.

So to get the Timestamp on the second transition short of looking at the issue history tab manually, you can create a custom data and time field, then on the transition create a post function for "Copy Value From Other Field" to copy the updated field to the new custom field so that any time that transition is executed it will log the timestamp in the custom field of the lat occurrence of that transition.

Then you can populate that data into a dashboard using any gadget that accepts custom fields, maybe something like the filter results gadget and adding in the custom field.

Regards,
Earl

[Laurent T.]

Hi,

Thanks for your answer.

Actually , here's what happens. I have 3 status, let's says: "In Progress", "Ready", "Finished"

When I go from "In Progress" to "Ready", the resolution changes to "Done". When I then go from "Ready" to "Finished", the resolution status goes to "Fixed" and the resolution date matches that last resolution change date. I want the date at which the status switched to "Ready" and/or the resolution switched to "Done".

What you're saying seems to be something that could work in this case. I'll try that asap and let you know. Thanks

[Earl McCutcheon]

Hi  Laurent,

Thank's for the confirmation on the setup, and the same setup should still do the trick.

Let me know how it goes, or if you run into any blockers so I can take a second look.

Regards,
Earl