Export over 1000 results in Jira Cloud

お困りですか?

アトラシアン コミュニティをご利用ください。

コミュニティに質問

Platform Notice: Cloud - This article applies to Atlassian products on the cloud platform.

要約

In Jira Cloud, exporting up to 1000 issues at a time using the Export feature from the Issue Navigator is not supported.

Below you can find two workarounds to accomplish this.

Workaround 1 - Export issues by using Google Sheets or Microsoft Excel

From the Issue Navigator (Filters > View all issues), after filtering the issues you want to export, you can click on Apps and select the desired option.

All the detailed steps can be found in the following article:

Apps dropdown menu with options to open the file in Google Sheets or Microsoft Excel. A Share button is also visible.


Workaround 2 - Export issues by adjusting URL parameters

This option doesn't work on the new issue search experience.

If you wish to proceed with the following workaround, if available on your instance, you can swtich back to the old issue search by clicking on More options (••• three dots menu) > Go back to the old issue search

Menu options for Apps, Share, Export, List View, Detail View, and additional options are available. A highlighted option offers to Go back to the old issue search. A search bar and other controls are also present.

Once you are on the old issue seach experience, you can follow the steps below.


Use the pager/start URL parameter to work around this issue by adjusting the index value to export issues from 1001 onwards. You will need to merge the results manually.

  1. Run a search on the issue navigator to get all the issues that need to be exported.
  2. Export the first 1000 issues using the standard export feature (Export > Export Excel CSV (all fields)):
  3. For the next thousand issues, right-click on the same option above and open in a new tab, you should get a URL string like below:

    https://<instance name>/sr/jira.issueviews:searchrequest-csv-all-fields/temp/SearchRequest.xls?jqlQuery=&tempMax=1000

    必要なのは URL 文字列のみのため、ダウンロードをキャンセルします。

  4. Append the &pager/start=1000 at the end of the URL string to instruct JIRA to export from index 1001 and above. Example:

    https://<instance name>/sr/jira.issueviews:searchrequest-csv-all-fields/temp/SearchRequest.xls?jqlQuery=&tempMax=1000&pager/start=1000

    ブラウザでこの URL にアクセスし、プロンプトが表示されたらファイルを保存します。次の 1000 件の課題についてもインデックス値を同様に調整します。例: &pager/start=2000

  5. エクスポートされた CSV ファイルを開き、必要に応じて手動で統合します。


最終更新日 2024 年 11 月 29 日

この内容はお役に立ちましたか?

はい
いいえ
この記事についてのフィードバックを送信する
Powered by Confluence and Scroll Viewport.