Uploaded image for project: 'Jira Service Management Data Center'
  1. Jira Service Management Data Center
  2. JSDSERVER-4520

"Customer Request type" field get encoded when exported to CSV

    XMLWordPrintable

Details

    Description

      NOTE: This bug report is for JIRA Service Desk Server. Using JIRA Service Desk Cloud? See the corresponding bug report.

      Summary

      When the user exports an issue from Service desk to CSV(all fields) the "Customer Request type" do not show the actual name of the request type, instead it shows a code from it.

      Steps to Reproduce

      1. Search for service desk issue that contains not default request types
      2. Click on Export Excel CSV (all fields)

      Expected Results

      On the exported csv, "Customer Request type" field shows the name of the request type.

      Actual Results

      It shows a code from it.

      Take note that the exported value is in the form of: Project_Key/Request_Type_Key

      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.

      Attachments

        Issue Links

          is incorporated by

          Bug - A problem which impairs or prevents the functions of the product. JSDSERVER-5745 Ability to export Request Channel Type

          • Low - Low priority issues
          • Gathering Impact
          is related to

          Bug - A problem which impairs or prevents the functions of the product. JSDCLOUD-4520 "Customer Request type" field get encoded when exported to CSV

          • Medium - Medium priority issues
          • Closed
          relates to

          Bug - A problem which impairs or prevents the functions of the product. JSDSERVER-5655 Export CSV - Ability to export Customer Organizations with their respective name instead of ID

          • Low - Low priority issues
          • Gathering Impact
          resolves

          Bug - A problem which impairs or prevents the functions of the product. JSDSERVER-1335 Can't import CSV generated from JIRA due to incorrect Customer Request Type format

          • Medium - Medium priority issues
          • Closed
          is cloned by

          JSDS-3785 Loading...

          JSMDC-1093 Loading...

          mentioned in

          Page Loading...

          Activity

            People

              siddharth@atlassian.com Siddharth Srivastava
              bcasaroli Bernardo Casaroli (Inactive)
              Votes:
              79 Vote for this issue
              Watchers:
              60 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Backbone Issue Sync