How to track Solved history bug of JIRA and export all of the history

[Harrica Rion]

Hi Jira…
I want to know, if is possible to track all of my history bugs issues and export all of the history issues to the Gsheet without open the issues?
For example I have 100 issues, I want know how to get all of the history issues. All of the comments on 100 issues, who handle it and when the asignee change to other user, I can get the history too.

[Jack Brickey · Accepted solution]

Hi @Harrica Rion , have you attempted using the export feature presented on the advanced search screen? You should choose the "Export Excel CSV (all fields)". You can also leverage the official excel extension to run your query directly from excel.

[Harrica Rion]

Hi @Jack Brickey 

Thank you for reaching out me.  :)
I just tried your solution, but I don't get the "Activity History" data that I require.

I obtained all of the fields and the ticket description.
However, I am unable to obtain the required activity history.
Please find attached a screenshot of the "Activity History" data that we require.

[Jack Brickey]

You cannot export history activity via CSV. Please see this open issue - JRACLOUD-38896 - Allow export of JIRA issue details into Excel . Given the age of the issue I would not hold much hope but you never know. There are addons that will allow you to capture this. You could also consider using the APIs. Also, while I do not know if it will work or not please try the Jira Cloud for Excel extension there is a chance it may work.

[Harrica Rion]

I see.. Got it @Jack Brickey  
thank you for the insight.

[Yuliia_Borivets_[SaaSJet]]

Hi @Harrica Rion 

If you want to export activity history, you can try do it with REST API or plugins. I described in this article:

How to export issue history from Jira?

For Jira Cloud, you can try the Issue History app from my team. Here, you can filter and export a list of issues you need (to CSV or Excel). Check it out and let me know if it helps. 

[Harrica Rion]

Hi @Yuliia_Borivets_[SaaSJet] 
Thank you for your info.
Let me check and review it and will discuss more further with my team.
Thanks !!

[Emre Toptancı _OBSS_]

Hello @Harrica Rion ,

In short: No, Jira doesn't give this data as a ready-to-use report. Since you are on the cloud, you can't query this data directly from the database. The only option to get this raw data is to get it via Jira public REST API. 

Most Jira users try to get this data because they want to see how much time an issue spent on a status or on an assignee. If that is your case, I suggest you use a marketplace app built for this.

If you are OK with using a marketplace app for this, our team at OBSS built Timepiece - Time in Status for Jira for this exact need. It is available for Jira Server, Cloud, and Data Center.  

Time in Status mainly allows you to see how much time each issue spent on each status or on each assignee. 

   

The app has Consolidated Columns feature. This feature allows you to combine the duration for multiple statuses into a single column and exclude unwanted ones. It is the most flexible way to get any measurement you might want. Measurements like Issue Age, Cycle Time, Lead Time, Resolution Time etc. 

For all numeric report types, you can calculate averages and sums of those durations grouped by the issue fields you select. For example total in-progress time per customer (organization) or average resolution time per sprint, week, month, issuetype, request type, etc. The ability to group by parts of dates (year, month, week, day, hour) or sprints is particularly useful here since it allows you to compare different time periods or see the trend. 

The app calculates its reports using already existing Jira issue histories so when you install the app, you don't need to add anything to your issue workflows and you can get reports on your past issues as well. It supports both Company Managed and Team Managed projects for Jira Cloud.

Time in Status reports can be accessed through its own reporting page, dashboard gadgets, and issue view screen tabs. All these options can provide both calculated data tables and charts.

  

Timepiece - Time in Status for Jira

EmreT