Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

What is the query to export all data?

Jamie Edmondson
Contributor
March 4, 2025

What would the query be to export all data from Jira? I know it can be limited to 1000 results, but I simply wanted to know what/if there is a JQL to export it all, or is it necessary to use the UI for that?

4 answers

1 vote
Mikael Sandberg
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
March 4, 2025

The short answer is that there isn't a "rule then all" JQL that would get you all work items beyond the 1000 limit. You would have to use the UI or the API in order to do it.

Jamie Edmondson
Contributor
March 5, 2025

Thanks. I don't need to go beyond 1000 records, its just that when you perform that "Export all fields", how is it pulling every field? I'd like to know how to call all of those fields from an API. I don't see all of that covered in their API documentation.

Mikael Sandberg
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
March 5, 2025

To do it via the API you can use Search for issues using JQL enhanced search (GET) 

0 votes
ELFAPP Technologies
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.
March 5, 2025

Hi @Jamie Edmondson 

If you're interested in using the API, there's an article here that explains how. It uses a Python library to extract the data via Jira APIs.  If you look further into the library's documentation and the arguments it has, it discusses that you can retrieve all fields or current fields. I would suggest looking into the code to see how it's implemented if you're curious.

0 votes
Mary from Planyway
Atlassian Partner
March 4, 2025
0 votes
Pasam Venkateshwarrao
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.
March 4, 2025

Hi @Jamie Edmondson 

if you want to  export entire Jira data I can suggest  by using Hierarchy for Jira Add-on refer the doc  https://www.adaptavist.com/blog/export-from-jira-to-excel will help you.. 

You will have to design your filter query to get the data that you want to export out

 

 

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
PREMIUM
PERMISSIONS LEVEL
Product Admin
TAGS
atlassian, team '25, conference, certifications, bootcamps, training experience, anaheim ca,

Want to make the most of Team ‘25?

Spend the day sharpening your skills in Atlassian Cloud Organization Admin or Jira Administration, then take the exam onsite. Already ready? Take one - or more - of 12 different certification exams while you’re in Anaheim at Team' 25.

Learn more
AUG Leaders

Upcoming Jira Events