How to List Issue Type changes of Issues in JIRA
Platform Notice: Data Center Only - This article only applies to Atlassian products on the Data Center platform.
Note that this KB was created for the Data Center version of the product. Data Center KBs for non-Data-Center-specific features may also work for Server versions of the product, however they have not been tested. Support for Server* products ended on February 15th 2024. If you are running a Server product, you can visit the Atlassian Server end of support announcement to review your migration options.
*Except Fisheye and Crucible
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.
Solution
Workaround
Log in to JIRA database.
Run the following SQL command to list the changes:
1
select * from changeitem where field = 'issuetype';Example result will look like following:
1
2
3
4
5
6
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)Was this helpful?