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

Question

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_fyzccb · Answer

Hi Ismael,

Thanks for the response.

Ismael Jimoh · Answer

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.