要約

Jira cloud natively does not offer a SQL query to delete old issues directly from the database. This is the kind of action that could potentially corrupt your data.

We are assuming that you are looking for permanently removing issues from Jira which is no longer required. Please be aware to take a backup of your issues before performing the below operations.

環境

Jira Cloud

原因

The reason for mass deleting issue in Jira could vary from improving the performance of the instance to decreasing the number of issues on the instance, or simply getting rid of obsolete issues which is no longer required.

ソリューション

The solutions below would be some ways to purge a large amount of issues from Jira.

1. Through Jira UI - This has a 1000 issue limit on the number of issues that can be modified in bulk

この一括操作では、複数の課題を同時に削除できます。複数のリクエストを削除するには、次の手順に従います。 

1. 必要なフィルターを使用して課題リストを生成します。
2. Select ... to the right of the screen > Select Bulk Change all 1000 issues
3. 一括操作を行いたい課題を選択し、次へを選択します。
4. Choose operation > Select Delete Issues and then select Next.
5. 可能な場合は、メール通知を送信したいかどうかを決定します。次へを選択します。
6. 一括操作を確認し、問題がなければ確認を選択します。

2. Using REST API

You can build a script that will run the REST API  that is mentioned in the Developer API page to delete multiple issues all at once. Sample of a curl request with the API https://your-domain.atlassian.net/rest/api/3/issue/{issueIdOrKey as below.

curl --request DELETE \
  --url 'https://your-domain.atlassian.net/rest/api/3/issue/{issueIdOrKey}' \
  --user 'email@example.com:<api_token>'

• developer.atlassian.com

3. Third party Plugin

Mass Delete for Jira makes the removal of large numbers of Jira issues easy. Unlike the bulk delete functionality provided by Jira, this add-on has no limit on the number of issues removed by one job. 

• Mass-delete-for-jira