How to export excel all fields in Jira by Java Programming ?

[Deepak Raj]

I have some Jira Jql.
After executing those jql in Jira I want to export all field to excel. I am able to execute jql programmatically and also able to fetch the fields individually.
But fetching all the fields individually takes too much effort and making the program very lengthy. I want to export the excel all fields.

[Deepak Raj]

Hi Ismael,

Thanks for the response. 

[Ismael Jimoh]

Hi Deepak,

JIRA does not have a simple script that can fetch all fields directly.

Your best bets are:

• Exporting from the UI(if you are not using this for anything past just export to excel).
• In your script, have all fields possible and grab the results for all(very tedious and messy as you would be doing a recursive getCustomFieldValue for all fields).
  
  

Other than these, I do not know of any other way you can do this and JIRA does not have a Rest API to export the search result.

If anyone has an idea how he can export it, please do share.