Jira-Tickets: Access to Data field "change history"

[Chris_Taylor]

Hello everyone,

I have to create a Tracking Board for bugs. Therefore I need some special date from the Jira-Tickets. There s existing a field named "Änderungshistorie" in German. I think it s "change history" in English. 

Is it possible to use the date for the board and how?

Is there any other way to access the date in "change history"? For example: An export to Excel with all fields don't include the field.

Best regards

Chris

[Emre Toptancı [OBSS] · Accepted solution]

Hello Chris,

Our team at OBSS created Timepiece - Time in Status for Jira app for this exact need. It is available for Jira Cloud, Server and Data Center.

Using Time in Status you can create reports on the dates of each issue status transition. For issues that visit the same status more than once, Time in Status has 4 different date reports that show the first/last transition to/from any status.

You can also report how much time each issue spent on each status, each assignee or even each user group. (useful for identifying bottlenecks in your process). You can also see the number of times each status or transition was used (very useful for inspecting reopen counts). 

All data can be exported as XLS, XLSX, CSV and all data can be accessed via REST API.

Timepiece - Time in Status for Jira

Emre Toptancı

OBSS

[Mehmet A _Bloompeak_ · Accepted solution]

Hi @Chris_Taylor ,

The data you need is available in Jira Rest API. It provides the exact status transition date and time for each issue. It returns json as below, then you need to extract and calculate.

Or you can try a marketplace app which does the extraction and calculation for you. Our team at Bloompeak developed 2 apps for the exact need.

• Status Time: It displays status entrance dates as well as other 2 other reports.
• Status Time Free: is limited version of the above app.
  
  

[Nic Brough -Adaptavist-]

It's not really a field, it's a display of all the changes that have happened to the issue.

You can't get directly to it, as it is just a pile of change data, and even if you could expose it as an export, you'd just get a large field with a load of text dumped into it.

There may be ways to get to the date you specifically need though - what exactly are you trying to get out of there?

[Chris_Taylor]

Thanks for the answer!

I need the time when the ticket status changed and the new status.