How to extract issue complete status history from JIRA?

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

2 answers

1 vote

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.

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

0 votes

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

Best regards,

Richard

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

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

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.