Exporting a full like of Issue history - including 27 custom fields for a specific time frame.

[Amanda Sugatan]

Hi! So I figured out how to export the issue history for a specific PROJ but the export is only giving me the history of the general field changes (ex: status/summary/priorityassignee): 

But what we are trying to export is a comprehensive list of all DCR’s Issue history for all fields within a specific timeframe.

How can we do this?

Thanks!

[Serhii Kibitkin_SAASJet_]

Hi @Amanda Sugatan 

According to your screenshot of the export, it looks like you are using Issue History for Jira Add-on, which my company developed.

You can export all changes from your project or 2-3 projects at once. 

Use JQL for this - example of query: "project in(Development, Design, Marketing) "

How to do export ALL changes for 1 project (3 projects) step-by-step:

Step 1 -  Open Column Manager and select fields with green labels that contain a number.

🟦 Blue labels with numbers mean that field changes have been added to the Add-on table.

🟩 Green labels with numbers mean that there are changes for these fields, however, these fields have not been added to the table.

⬜ Grey labels - this is initial state of the field without >1 change (example: field Created)

Step 2 - Select those fields where there are only numbers with the number of changes

Step 3 - Click Apply button to add those All fields with changes to the table. 

Step 4 - Export ALL changes from the table to the XLS file. 

Done. 

Watch a short video step-by-step how to export All changes 

[Amanda Sugatan]

This was the most helpful! Thank you so much Serhil!

[Rahul_RVS]

Hi @Amanda Sugatan 

You can also use Jira Rest Api's to pull this information and build your own custom solution.

However if you need detailed reporting to track changes for multiple issues, you may want to have a look at a mktplace app for the same.

We have built an app to extract changelog data in a simple and easy to use interface. The data can be exported to a CSV file as well.

Issue History Reports

Do give it a try.

Disclaimer : I am part of the app dev team

[Aron Gombas _Midori_]

You can export the work item history using the Better Excel Exporter.

See the samples

It supports all fields and it works cross-project (in fact, you can run any JQL and then export the history of the resulted work items). You can select the "fix" fields to appear on the left, and the history columns (what field? who? when? old value? new value?) will be added on the right.

You can get this in normal (non-repeating) mode, which is better for human reading:

... or in repeating mode, which is better for data processing. In this case, the cells on the left will be repeated for each row of the same work item:

(Discl. this is a paid and supported app developed by our team. Free for 10 users!)

[Tuncay Senturk _Snapbytes_]

Hi @Amanda Sugatan 

Unfortunately, you can’t get that level of detail out-of-the-box in Jira. The built-in history exports are limited to certain standard fields like status, summary, priority, and assignee.

If you’re open to using a free Marketplace app, SnapMetrics has an Issue History Report that can give you a comprehensive list of all field changes (including custom fields) for your issues, and you can filter it for a specific project and timeframe or the author of the changes. You can then export the results.

I am one of the developers behind this app, and I am pleased to help if you have further questions.