Priority field in the export set sends backend values

[AmanPratapS7233]

Hi All,

I have created an export set with many fields being exported along with priority but, backend values are being send in the csv (ex - 1,2,3) instead of frontend values (ex - P1, P2). What should I do next to send the frontend labels ?

Thanks

[Tanushree Maiti]

Hi @AmanPratapS7233 

Option 1: OOB - Update sys properties:

Use system properties to export the display value or raw value of fields and the field label or field name for headers.  Refer: System properties for display value and header 

Example for  CSV

Example: glide.export.csv.raw.value = false (default) glide.export.csv.column_header_label = false (default)

Example: glide.export.csv.raw.value = true glide.export.csv.column_header_label = true

Option 2: Trick - passing parameter in URL.

https://<your_instance_name>/incident_list.do?CSV&sysparm_display_value=false

[AmanPratapS7233]

Thanks for the response.

Option 1: Will it affect all the exports of just this export set ? Because, I just want to modify the functionality for this export set.

Option 2: Same doubt, will it only modify this export set or all the exports ? Also, how to achieve this exactly ?

[Tanushree Maiti]

For option 1  : Do you think if 

 glide.export.csv.raw.value = true glide.export.csv.column_header_label = true

Can any business user  read/understand this metrices properly as it is contains backend id.

It will impact all export set but false is OOB value. You can go with it.

glide.export.csv.raw.value = false (default) glide.export.csv.column_header_label = false (default)

In my client instance, it is false only.

[Rakesh_M · Accepted solution]

Hi @AmanPratapS7233 ,
Did you try changing the Column values to Use Display value