nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

How to export over 1,000 filter results with specified column data?

Jerry Yen_rdo47p

Hello,

We have a requirement to export data for an audit.

The auditors have specified a list of data columns that must be in the report.

We've built the filter for the report, but for whatever reason the export to CVS and Excel will not export exactly what is in the filter output.

Also, the number of records exceed 1000.

In JIRA server version the filter will tell you exactly how many records are pulled. To export records above 1,000 I just added this to export URL:

?jqlQuery=&tempMax=1000 (for first 1,000)

?jqlQuery=&tempMax=1000&pager/start=1000 (for 1,001-2,000)

?jqlQuery=&tempMax=1000&pager/start=2000

?jqlQuery=&tempMax=1000&pager/start=3000

For whatever reason the cloud version won't give me the total, won't export the columns I specified in the filter, and the old method of pulling records above 1,000 doesn't seem to work.

Accepted answers

Bill Sheboy

Hi @Jerry Yen

First, a disclaimer that I do not work for Atlassian or any marketplace vendor. I am just another Jira user. With that out of the way...

I do not believe exporting that many issues is possible with Jira Cloud's built-in features.

For some workarounds please consider:

Using the Jira addon for Google Sheets: https://community.atlassian.com/t5/Jira-articles/How-to-export-more-than-1000-issues-using-Google-Sheets/ba-p/1810436
Use the REST API issue search, and the paging parameters, to export the data in JSON format
Investigate the Atlassian Marketplace for apps to perform this type of reporting

Kind regards,
Bill

All comments

Bill Sheboy

Hi @Jerry Yen

First, a disclaimer that I do not work for Atlassian or any marketplace vendor. I am just another Jira user. With that out of the way...

I do not believe exporting that many issues is possible with Jira Cloud's built-in features.

For some workarounds please consider:

Using the Jira addon for Google Sheets: https://community.atlassian.com/t5/Jira-articles/How-to-export-more-than-1000-issues-using-Google-Sheets/ba-p/1810436
Use the REST API issue search, and the paging parameters, to export the data in JSON format
Investigate the Atlassian Marketplace for apps to perform this type of reporting

Kind regards,
Bill

Jerry Yen_rdo47p

So it looks like there's the option of exporting to Excel (app) and Google Sheet, and you can specify exporting 1,000 at a time:

Export over 1000 results in Jira Cloud | Jira | Atlassian Documentation

I need to figure out the right URL to use.

But there's still the issue of export to CSV/Excel (not app) is not exporting the columns in my filter. I don't understand why this is a problem. Common sense dictates that if you built a filter with specific data columns, you expect the export to contain those exact data columns.

The very idea that customers have to pay for 3rd party plugin to export data seems ridiculous to me. If the feature is not avail natively then Atlassian should buy the plugin and make it a standard feature.

Bill Sheboy

Regarding the filter and columns, are you selecting to export the filter fields or something else?

Also, I recall a problem where a filter can be updated and not detect the current column configuration when the last thing to change is the columns. The way to fix that is:

get the columns configured how you want,
make a temporary change to the filter, such as the ORDER BY
save the filter
then set your ORDER BY (or other temporary change) back, and
save the filter again

Jerry Yen_rdo47p

This worked! Thank you!

Interestingly, the export to Excel (app) and export to CSV (in 1,000 record chunks) both had issues, but between the two I was able to obtain the data needed.

Had to export the data to CSV in 7 chunks, manually merge then copy/paste the missing data from one report to another, but I got it working.

Moving forward, I think this task might be easier done from looker. Just need to make sure Looker is importing the right data.

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira

cloud

jira-cloud