How to List Issue Type changes of Issues in JIRA
要約
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.
回避策
- 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)
最終更新日: 2016 年 2 月 26 日
Powered by Confluence and Scroll Viewport.