Is there a way to export the history?

[BrianB]

This question is in reference to Atlassian Documentation: Viewing an Issue's Change History

We're looking to archive and delete aged JIRAs. Is there a way to capture change history as an export like the rest of the issue data?

[Georges Moubarak · Accepted solution]

Hi @Brian Bashynski,

This is not possible from the application, but you can do it from the db using the following query

select 
jji.issuenum,
jit.pname as IssueType,
jji.SUMMARY,
jci.OLDSTRING as OldStep,
jci.NEWSTRING as NewStep,
jcg.AUTHOR,
jcg.CREATED as changeDate
from changeitem jci
join changegroup jcg on
jci.groupid = jcg.ID
join jiraissue jji on
jcg.issueid = jji.ID
join issuetype jit on
jji.issuetype = jit.id
where jci.FIELD = 'status' -- this is used if you want only the transition history
and jji.project =10003; --this is used if you want to filter for a project

:

[BrianB]

Thank you. I came up with something similar. I guess I was looking for a shortcut to thinking.