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

Jerry Yen
Contributor
November 18, 2024

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.

1 answer

1 accepted

2 votes
Answer accepted
Bill Sheboy
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
November 18, 2024

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:

Kind regards,
Bill

Jerry Yen
Contributor
November 18, 2024

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
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
November 18, 2024

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

 

Like Jerry Yen likes this
Jerry Yen
Contributor
November 19, 2024

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.

Like Bill Sheboy likes this

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
PREMIUM
TAGS
AUG Leaders

Atlassian Community Events