How to extract issue complete status history from JIRA?

Question

Hi all,

Using REST API and Perl, how could I get the complete status history of an issue from JIRA?

It means that for a given issue, it will collect all the general information and all the statuses the issue had during its cycle of life.

Does it make sense?

Best regards,

Richard

Martin Rýznar · Answer

I need this too. Have you found any solution how to get these datas directly from DB using SQL?

Richard Coffre1 · Answer

Is it possible to do it directly in the database by selecting data from tables such as jiraissue, changegroup, changeitem?

Best regards,

Richard

Jobin Kuruvilla [Adaptavist] · Answer

When you use GET issue (https://docs.atlassian.com/jira/REST/cloud/#api/2/issue-getIssue), you can get the full change history by requesting changelog, as described in the documentation.

You can then extract the status changes from the change log.