Heads up! On March 5, starting at 4:30 PM Central Time, our community will be undergoing scheduled maintenance for a few hours. During this time, you will find the site temporarily inaccessible. Thanks for your patience. Read more.
×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?
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.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
To do it via the API you can use Search for issues using JQL enhanced search (GET)
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi @Jamie Edmondson
Please check this article. Hope it will help: https://community.atlassian.com/t5/user/viewprofilepage/user-id/3973112
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.