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.
- JRACLOUD-25493 - 課題詳細を取得中... ステータス
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:
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.
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.
- Run a search on the issue navigator to get all the issues that need to be exported.
- Export the first 1000 issues using the standard export feature (Export > Export Excel CSV (all fields)):
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 文字列のみのため、ダウンロードをキャンセルします。
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
- エクスポートされた CSV ファイルを開き、必要に応じて手動で統合します。