Can i get all the tickets activities history by date?

[Benjie]

I am trying to get a report on how many times tickets have changed status from "ready to test" to "Reopened" in certain period. Is this achievable for Jira Cloud?

e.g.

I have 3 tickets A, B and C. It was reopened 2,3,4 respectively. I want to be able to get the data as per below

Ticket Number | FromStatus | ToStatus | TimesStamp | Updater name |

[Julia Denys [SaaSJet]]

Hi @Benjie 

Yes, you can use Time in Status for Jira Cloud reports to get the needed information.

With this add-on, you can not only get the report of how many times an issue went from status to status, but also the report of the time that a particular assignee was assigned to each issue, the report of how long your issues has been staying in each status, how many times an issue has been in each status, and much more.

This add-on has an advanced filtering system by project, filter, report, label, sprint, and assignee (also by issue creation, update, and resolution date).

Moreover, you can view your data in charts (Pie, Bar, and Area Charts). And, of course, you can export the data both as numeric reports and graphical.

You can also try the Issue History add-on, it will show you the history of all the changes that had been made in selected issues.

[Benjie]

Thanks for the suggestion @Julia Denys [SaaSJet] . will give it a try

[Ste Wright]

Hi @Benjie

Not in Jira Cloud as standard.

The only thing I know which is (near) what you're looking for is history searches in Jira - for example, you could search for all issues which have changed for your two statuses after the start of the day:

status changed FROM "Ready to Test" TO Reopened AFTER startOfDay()

Alternatively, you could search for all issues which have moved from resolved to unresolved during the last two days:

resolution changed FROM Done TO EMPTY DURING (2019-11-01, 2019-11-02)

There is some great information on these on this blog post. However, the results will be the same as you get in a normal issue search, so this will only include metadata you have access to on your environment (eg. current status, last updated date, etc).

If you want more specific details as fields, you'll need to consider using add-ons to create custom fields to house this data. Apps you could consider:

• Apps mentioned in this answer for counting how many times a transition has been made in a custom field (using functionality from Jira Misc Workflow Extensions)
• Time in Status - which has some useful tracking for transition / status counting
• Investigate if a scripting app such as ScriptRunner will allow you to populate custom fields with this data

Ste

[Benjie]

@Ste Wright thanks for replying and apology for responding too late.

I have resorted to create my own google spreadsheet and get the data through REST API.