Custom export option for JIRA filtered issues

[Sambit Choudhury]

My goal is to get the custom field value in the filtered issue report. But the custom field has JSON value and I am not getting it in human readable format in the excel sheet. 

Please let me know if I can customize the export option of filter issues. 

[Don Masten]

Have you tried exporting to HTML then copying into excel?

[Sambit Choudhury]

Tried exporting to HTML but getting blank value, in excel format getting the raw original JSON. So want to make it as human readable format in HTML or JSON.

In some instance I can see the data in the selected column in UI but it's not consistent. 

If I can customize the report to show the JSON data into individual cells of excel that will be great. I want to know if any customization option available for filtered issues export.

[Nic Brough -Adaptavist-]

What type of field is it?  Is the data in the field formatted in JSON in the UI?

[Sambit Choudhury]

It's a custom fields having JSON data in value and same stored in DB. But in UI we are showing the respective key and value as readonly field.

[Nic Brough -Adaptavist-]

So there's nothing wrong with the export, it's excel not being told it needs to reformat the JSON into something else.

[Sambit Choudhury]

If I want to do any customization into exported excel using JSON data, is there provision to do this kind of customization. Can we create and upload any plugin which can be added as drop down option while doing export for filtered issues.