It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Can i get all the tickets activities history by date? Edited

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 |

2 answers

0 votes
Stephen Wright Community Leader Nov 01, 2019

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

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 Issue History add-on, it will show you the history of all the changes that had been made in selected issues.

Suggest an answer

Log in or Sign up to answer
Community showcase
Posted in Jira

Demo Den Ep. 7: New Jira Cloud Reports

Learn how to use two new reports for next-gen projects in Jira Cloud:  Cumulative flow diagram and Sprint burndown chart. Ivan Teong, Product Manager, Jira Software, demos the Cumulative ...

274 views 1 2
Join discussion

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you