You can export change histories with the following add-ons:
The SQL for JIRA plugin supports it seamlessly. Simply, execute the SQL below:
select * from issuechanges c where c.issueid=10000
it will fetch the full change history for the given issue id (10000 in the example).
Note: the SQL for JIRA plugin provides a pure JDBC driver that you can use to connect remotely to the JIRA API from any JDBC compliant tool (Birt, Jasper Reports, custom Java program, etc) and export data from there in the usual way.
How we can customise the query for scenario given below.
We have to export the list of issues of Project ORR and Issutype RTM, which got changes last week with following information.
1) List of issues, With Issue key
2) What changes done to the field ( Before value and current value)
3) Who made the changes
4) When the changes sone)
In case anyone is interested in the solution for JIRA Cloud, there's now plugin that exports history of changes to JIRA issues - Advanced Export.
Any custom or standard field can be exported with every change as a separate row to make it easy to analyse in spreadsheet or postprocess in any other way.
Full disclosure: I'm the author
Hey everyone! My name is Sarah Schuster, and I'm a Customer Success Manager in Atlassian specializing in Jira Software Cloud. Over the next few weeks I will be posting discussion topics (8 total) to ...
Connect with like-minded Atlassian users at free events near you!Find a group
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no AUG chapters near you at the moment.Start an AUG
We're bringing product updates and pro tips on teamwork to ten cities around the world.Save your spot