Is it possible to export issue history of statuses?

Vladimir Sumilin
Contributor
June 12, 2023

Dear all,

I think I am not the first one, who is asking this question, but I was searching for the answer on Google and have not found the free answer without installing any other software. Is there any software from Atlassian or another way to make it? 

 

Best regards,

Vladimir

6 answers

1 accepted

2 votes
Answer accepted
Rahul_RVS
Atlassian Partner
June 13, 2023

Hi @Vladimir Sumilin 

If you would be interested in a mktplace app to get this data, you can try

Time in Status Reports 

The add-on provides the status transition details in the entire issue lifecycle.

And you can export to a CSV format easily

Also there are 20+ reports in the app which help to meet a wide range of use cases.

Do try it out. It is free upto 10 users.

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

TIS - Status Transition Details.PNG

1 vote
Casper
Contributor
June 13, 2023

Hi Vladimir,
You can download a free third app to solve your question, you can customize and export status history as well, I'm personally use this app there a friendly UI & UX, easy to use, and has a good stack of functionality.

Third App:
Screenshot 2023-06-13 at 12.29.04.png

1 vote
Aron Gombas _Midori_
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
June 12, 2023

It is not possible with the built-in features, unfortunately

It is possible with our Better Excel Exporter app:

jira-issues-selected-fields-with-change-history.png

It is also possible to repeat value along the rows, just see the sample exports.

(Discl. it is a paid and supported app developed by our team.)

Vladimir Sumilin
Contributor
June 12, 2023

Hi @Aron Gombas _Midori_ 

Is it possible with your app to get information about status changes? 

I would like to obtain information regarding the specific status changes and corresponding dates.

For example: 

screenShot.PNG

Aron Gombas _Midori_
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
June 13, 2023

Yes.

As you can see in the spreadsheet screenshot above, you can filter the "Changed field" column to "status" only. Then you will see all status changes, and nothing else. The corresponding date is in the "Change time" column.

It is that simple.

0 votes
Petru Simion _Simitech Ltd__
Atlassian Partner
November 3, 2024

The app we developer, CIFJ - Issue History Dashboard app will allow you to achieve this.

https://marketplace.atlassian.com/apps/1235591/cifj-issue-history-dashboard?hosting=cloud&tab=overview

You will be able to filter your search and also export the data in CSV format without the need to process the JSON Rest call result yourself.

0 votes
l.kustrzynski December 4, 2023

The Advanced Export application allows to do it. You can export history of changes of any field.

There is a trial version that can be accessed for free. Try it.

 

history.jpg

Bill Sheboy
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
December 4, 2023

Hi @l.kustrzynski 

In accordance with the community guidelines for marketplace and solution providers, please ensure you disclose in the text of your post your relationship to a vendor when recommending their products.

Please see the community guidelines for more information.

https://community.atlassian.com/t5/Marketplace-Apps-Integrations/Atlassian-Community-online-guidelines-for-Marketplace-and/ba-p/689723

Kind regards,
Bill

0 votes
Bill Sheboy
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
June 12, 2023

Hi @Vladimir Sumilin 

What problem are you trying to solve by exporting the issue history of status changes?  Knowing that may help the community to offer other suggestions.

Until we know that...There is no built-in export of the issue history information.

You can call the REST API function to get the changelogs, by pages, and then filter for what you needed from the results.  Please look here for information about that function: https://developer.atlassian.com/cloud/jira/platform/rest/v3/api-group-issues/#api-rest-api-3-issue-issueidorkey-changelog-get

Kind regards,
Bill

Vladimir Sumilin
Contributor
June 12, 2023

Hi @Bill Sheboy 

In order to streamline and consolidate our projects effectively, it has been identified that merging the two similar projects into one would be more beneficial than making changes separately. Consequently, it is crucial to transfer the data from one project to the other, while also preserving the historical statuses of the respective issues. This consolidation not only ensures better project management but also facilitates comprehensive analytics, as it allows us to consider all relevant data that might otherwise be overlooked.

Thank you for your help! 

Best regards,

Vladimir

Bill Sheboy
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
June 13, 2023

Thank you for that information.  When you want to merge project issues and want to preserve something like issue status history, all possible status values must be in the target project...even if they are not used any longer.  Otherwise when you move the issues Jira will ask you to provide replacement values for each status.

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
STANDARD
TAGS
AUG Leaders

Atlassian Community Events