How to List Issue Type changes of Issues in JIRA

Still need help?

The Atlassian Community is here for you.

Ask the community

Summary

The purpose of this article is to show how to get a list of issue type changes of issues in JIRA. The changes can be viewed in "History" tab on each issue. This article will help on getting a list of issue type changes of all the issues in JIRA by executing a SQL command against the JIRA database.

Workaround

  • Log in to JIRA database.
  • Run the following SQL command to list the changes:
select * from changeitem where field = 'issuetype';
  • Example result will look like following:
select * from changeitem where field = 'issuetype';
  id   | groupid | fieldtype |   field   | oldvalue |  oldstring  | newvalue | newstring
-------+---------+-----------+-----------+----------+-------------+----------+-----------
 10007 |   10005 | jira      | issuetype | 2        | New Feature | 3        | Task
 10000 |   10000 | jira      | issuetype | 2        | New Feature | 3        | Task
(2 rows)
Last modified on Feb 26, 2016

Was this helpful?

Yes
No
Provide feedback about this article
Powered by Confluence and Scroll Viewport.