How to List all the Issue Status Transitions from Database in Jira
プラットフォームについて: Server および Data Center のみ。この記事は、Server および Data Center プラットフォームのアトラシアン製品にのみ適用されます。
サーバー*製品のサポートは 2024 年 2 月 15 日に終了しました。サーバー製品を利用している場合は、アトラシアンのサーバー製品のサポート終了のお知らせページにて移行オプションをご確認ください。
*Fisheye および Crucible は除く
要約
The purpose of this article is to show how to get a list of all the issue status transition from database in Jira. The status transition can be seen at the "History" tab of the issue. This article will help on getting a list of all issue status transition of all 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 status transitions:
SELECT changeitem.oldstring, changeitem.newstring, changegroup.author, changegroup.created FROM changeitem JOIN changegroup ON changeitem.groupid=changegroup.id WHERE changeitem.field='status';- Example result will look like following:
oldstring | newstring | author | created
--------------------+--------------------+----------+-----------------------
Open | Review | admin | 2015-05-25 09:27:46+08
Resolved | Closed | admin1 | 2015-05-25 09:51:30+08
Open | Closed | admin | 2015-05-25 09:59:22+08
Investigation | Analysis | admin2 | 2015-05-25 10:44:22+08
Analysis | Consultation | admin | 2015-05-25 10:51:13+08
Open | Resolved | admin | 2015-05-25 10:53:26+08
Resolved | Closed | admin1 | 2015-05-25 10:53:29+08
Change Approval | Change Development | admin | 2015-05-25 11:35:27+08
Open | Review | admin2 | 2015-05-25 12:05:58+08
Open | Resolved | admin | 2015-05-25 12:15:20+08
Resolved | Closed | admin | 2015-05-25 12:15:23+08
...
最終更新日 2024 年 11 月 25 日
Powered by Confluence and Scroll Viewport.