How can I get a list of the latest status changes across all tickets in a project

[Marcin Wolny]

I would like to see a list of the latest status changes across all tickets in my project.

For example:

Ticket | From | To | Date

TCK-1 | ToDo | Done | 2022-12-06 09:32

TCK-2 | New | ToDo | 2022-12-06 09:40

How can I generate such a report?

In general I'd like to find tickets that were moved from New into ToDo and then back to New, so this table would allow me to find all the tickets that were moved back in the statuses and see if it was a quick fix to an accidental status change, or was it something done after a longer period of time.

[Gokaraju gopi · Accepted solution]

Please refer below link. It might be helpful

https://community.atlassian.com/t5/Jira-questions/Get-Issue-Change-History-using-Script-Console-not-giving-result/qaq-p/1742033

[Marcin Wolny]

Do I understand it right, that it's only available with the ScriptRunner? Any way to either run it without the ScriptRunner or... get a similar result in some other way?

[Gokaraju gopi]

You can do in automation rules as well. You need to log the data when issue is transitioned from to do to done and new to todo. To see logs you need to open audit logs of jira. Following is automation rule example

[Yuliia_Borivets__SaaSJet_]

Hi @Marcin Wolny 

You can also get status changes report with Issue History for Jira add-on. There are different options to filter the issue list, including project and date range.

The app is developed by my team. Let me know if you have any questions. You can check if it's good for your case with a 30-day free trial.

[Marcin Wolny]

That's actually exactly what I need :) Cheers.

[Madhu_RVS]

Hi @Marcin Wolny 

For a readymade solution, if you would be interested in a mktplace app, you can try out our plugin,

Time in Status Reports 

Disclaimer : I work for RVS, the vendor for this app