Data extraction from Jira

[Gary]

Hi,

I'm looking for some help. I was wondering if there was anyway of extracting dates that issues were transitioned to 'Done' status. I know I can pull CSV files out of jira from the search area, but there doesn't seem to be anyway to find the date of transitions in that search function. I know that the data is available as within the issue history it shows the date is transitioned to done. I need to retrieve this data to create a report for my boss and as there is a lot of issues I can't do this manually by looking at each issue individually.

Any help would be greatly appreciated.

Cheers,

Gary

[Natalia_Kovalchuk_SaaSJet_ · Accepted solution]

Hi @Gary,

You’re right, the standard search and CSV export don’t show transition dates automatically. Every issue’s history contains that information, though manually collecting it from many issues would take a lot of time.

I can recommend you try to use Issue History for Jira (Work Item History) app from my team. 

Using it, you can do the following:

• View the whole history of issue status changes.
• Filter by date, project, user, or status (e.g., issues transitioned to the status "Done").
• Export the data in CSV or Excel formats.

The exported file will look like this:

With the help of the app, you can easily extract dates when issues were transitioned to the "Done" status.

Hope it helps you! 

[Gary]

Hi Natalia,

That's great. Thanks alot for your help.

Cheers,

Gary

[Natalia_Kovalchuk_SaaSJet_]

I'm glad I could help. 😊

[Walter Buggenhout · Accepted solution]

Hi @Gary,

If the resolution is being set on your issue when an issue transitions to the Done status, you should be able to look at the resolved field to get that date.

Issue history does not export out of the box from Jira, as the standard export is based on the results of a JQL search. And this returns the current state of your issue, not the history.

If you can process your Jira data with a (BI) reporting tool e.g., you could use the processed data through that solution probably for more advanced scenarios.

Hope this helps! 

[Gary]

That's great thanks for the help Walter!

Cheers,

Gary

[Tomislav Tobijas · Accepted solution]

Hi @Gary ,

Yeah - users usually build some kind of automation that 'logs' transition date/time into a specific field (date or paragraph field types).
In short, you could use smart values such as {{now}} or {{fieldChange}} to input that data somewhere else (on specific transition).

Additionally, you could use the system field named Resolved. This value is automatically entered when item resolution is set. If you only set resolution (whether automatically or manually) once you enter status "Done", this could be a way to go as well.

Cheers,
Tobi

[Gary]

Thanks for the help Tobi. That's perfect.

Cheers,

Gary