Extraction of the Date and Time of Status Changes to “In progress” and “Resolved”

Question

I am trying to extract a report from Jira Cloud (Jira Service Management, project SD) containing all issues created between 01/01/2026 and 01/31/2026 (a total of 708 issues), including the exact date and time when each issue first transitioned to the “Em andamento” status and later to the “Resolvido” status. I have successfully validated my authentication and confirmed that I have permission to view all issues, as I am able to export all 708 records normally through the user interface. However, when attempting to retrieve the complete status transition history through technical queries, I encounter errors such as 410 (Gone), 400 (Bad Request), and 404 (Not Found) when searching for issues or accessing the changelog, whether via shell commands or JQL. I have also tested different variations of requests and parameters, but I am still unable to retrieve the transition timestamps. I would like to understand what the correct and currently supported method is for extracting the full status change history of issues in Jira Cloud, and what the recommended approach would be to reliably obtain this information for a large volume of tickets.

Birkan Yildiz _OBSS_ · Answer

Hello @Jairo Monteiro ,

You can build a custom solution using the Jira REST APIs, but it can become a lengthy and time-consuming project. You’d need to pull issue changelogs and parse them to extract the data you need, which can be complex and error-prone. If you prefer a faster and more reliable option, you might consider trying a Marketplace app built for this purpose.

Timepiece - Time in Status for Jira has a 'First Transition To Status Date' report, exactly what you are looking for.

With Timepiece:

You’ll get a list of all issues within your chosen date range,

The selected statuses will appear as columns,

And you’ll see the exact first transition date and time for each status. This way, Timepiece provides the complete report you need; there is no need to work with the API or changelog.

You can configure the report with one-click using custom JQL you already have, or use Timepiece’s Rovo-powered Assistant, and it can generate a report for you.

Once the report is ready, you can export it to Excel or CSV for easy sharing or further analysis. Moreover, you can directly create reports for past and ongoing issues, just after installation.

You can find Timepiece - Time in Status for Jira on the Atlassian Marketplace. Hope this helps.

Full disclosure, I'm on the team that makes Timepiece - Time in Status for Jira.

Best,
Birkan

Danut M _StonikByte_ · Answer

Hi @Jairo Monteiro,

You could use the endpoints of the Jira Cloud REST API to retrieve issue changelogs, then parse them to extract the required information. However, this approach is complex and prone to errors.

My recommended approach would be to search for an app (plugin) on Atlassian Marketplace that is capable to generate this as a report.

If you are willing to try an app, our Great Gadgets app offers some gadgets capable do generate such a report.

Here is how you can do this:

* Add the Control Chart gadget to your Jira dashboard
* Configure it with a filter / JQL that returns all issues created between 01/01/2026 and 01/31/2026 and custom time interval 01/01/2026 to 01/31/2026 
* Configure "Cycle starts" = status In Progress and "Cycle ends" = status "Done" 
* At Multiple cycles choose Display as one cycle. 
* Check the option to display the Data tab (on its More Setting tab)

As a result, it will display a chart will also the issues that had such cycle during the time interval.

On its Data tab you will find the report you need. You can then export it in CSV format.

Hope this helps. If you need any help, feel free to contact support@stonikbyte.com for assistance.

Danut

Rahul_RVS · Answer

Hi @Jairo Monteiro

You can write your own custom solution using Jira Rest API's. However this could be a lengthy and time taking project. Or if you would like to explore a mktplace app for this requirement, you can try out

Time in Status Reports

With this app you generate time in each workflow status for multiple issues with multiple filter and grouping options.

With Status grouping feature, can help you define your own issue age time and view the averages of the same. Also the app has 20+ reports to meet a variety of use cases.

Also the app has a custom calendar option to define your working hours and days which will be taken in calculation for time in status.

More details here.

I have added the screen grab of Status Transition details reports, where in it shows the date and timestamp of the status transition.

Disclaimer : I am part of the app team for this add-on