Custom Field column listing display when exporting as .csv

[Deleted user]

I had made a reference to "https://community.atlassian.com/t5/Jira-questions/Custom-request-types-not-sshowing-corectly-when-exported-to-CSV/qaq-p/869229"

Would like to inquire whether there is any fix to this yet? If it's yet to be fixed, is there an expected due date? 

Currently have been manually searching for the request type using the Issue Key however this is tedious and time consuming:

Appreciate a revert soonest - we may consider switching to a different service desk.

[Andy Heinzer]

Are you using the Cloud platform of Service Desk or the Server platform of Service Desk?

There are a pair of bugs documented for this problem of custom request types not being exported properly in CSV for server and cloud respectively:

• Server - JSDSERVER-4520
• Cloud - JSDCLOUD-4520

While neither of these bug tickets have been resolved yet, however the server bug does have a work-around where you can go to the SQL database of Jira and run the following query to extract the request-types:

Workaround

Run this SQL query from the database:
NOTE this is written in PostgreSQL syntax and may need to be modified for for your database type:

 select vp."KEY" as project_key, vpf."NAME" as Request_type_Name, vpf."KEY" AS request_type from "AO_54307E_VIEWPORT" vp join "AO_54307E_VIEWPORTFORM" vpf on vpf."VIEWPORT_ID" = vp."ID";

Then base on the KEY to find the NAME.

If you're using Jira Cloud, there is not a simple way to extract this data from this platform.  It might be possible take a backup of your cloud site and then import that data into the latest version of Jira Service Desk Server.  At which point you could use the same SQL workaround that the server bug ticket has, but I admit this could be a significant amount of work just to perform this work-around.

[Angélica Luz]

Hi Syazni,

I've checked the bug but there are no updates and we don't have a date of when it will be fixed.
For your reference, you can find our policy on how we prioritize bug fixes here.
I've just tested on my cloud instance and it shows this information when I export the issues and open using Google Sheets:

It was showing the "code" only for a request type that was hidden from the portal.
I know that it's not the best format, but it looks like it's better to check what is the request type.

Have you downloaded a new CSV file? Is this still showing a code?

Regards,
Angélica