Fields in Search Issues results not included in Export

Question

The following fields are not appear on the extract (CSV) but are on the search issues summary screen results.  These fields are critical to my analysis, why are they not coming through on the CSV and what happened to the HTML export???

- Request Type (Service Desk Field)

- Organizations (service Desk field)

Additionally, all custom fields are coming through to the CSV as 'custom field'  Why would you not include the name of the field?  It creates extra work for me to go in an re-map all the fields that are all properly setup in the system.  In this case, both Request Type and Organizations are in fact NOT custom fields, but rather they are standard service desk fields

Jack Brickey · Answer

@Sue Marmion, I am on cloud as well. You mention "none of the JSD fields will export" but I don't think that is really true or what you mean. Regarding the two specified fields: request types and organizations, they are exported but as you point out the data is less than ideal at best and unusable in reality.

Organizations - is shown as Custom field (Organizations) and the value appears to be a reference ID, e.g. 1, 2, 3. Likely a simple value associated with the order of creation but not sure as I only have one org. :-)

Request Type - is shown as Custom field (Customer Request Type) and the data there is unusable, e.g. project_key/fdf01355-ef72-4103-8f90-e46df1b76d54. So good luck w/ the decoder ring on that. :-(

you might have a look at the Exporter addon for cloud. No experience with this so can't say if it will help.

Sue Marmion · Answer

unfortunately we are on cloud, that plug in is only available for server.....arrrggghhh

Tarun Sapra · Answer

You can export the fields using an plugin - Better excel plugin

Integration features

* You can export Excel reports directly from the Queue view (with all tickets in the queue). (supported since Better Excel Plugin 2.2.0)
* You can export the JIRA Service Desk-specific custom field types, like SLA, Request Participants, Customer Request Type, etc., to Excel.
* Better Excel Plugin also offers a reporting template that includes several pivot table and pivot chart worksheets to report SLA by projects, assignees, request types and request participants.

http://www.midori-global.com/products/jira-better-excel-plugin/documentation/integrations#jira-service-desk