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

The SLA information is not included in the Excel and HTML export

XMLWordPrintable

      Summary

      The SLA information is not included in the Excel and HTML export from Issue Search. This is preventing the user to export the relevant information for reporting purposes.

      Steps to Reproduce

      1. Create some issues with some SLA in Service Desk project.
      2. Go to Issue Search and try to export these issues via Excel, HTML or Printable

      Expected Results

      Issues exported with SLA information.

      Actual Results

      Issues are not exported with SLA information:

      Workaround to get SLA values exported to spreadsheet

      Use SLA Reports in Service Desk.

      1. Go to project settings > Reports > Create new report
      2. Add series and configure report as desired
      3. Once the report has been saved and displayed, drill down by pressing the number on the list:
      4. The list get drilled down to the issue list with SLA parameter shown:
      5. Click Export CSV, and the value gets exported (shown in hours):

        1. HTML_export2.png
          HTML_export2.png
          3.12 MB
        2. Jira 2018-09-11T20_41_13+0800.xls
          112 kB
        3. Jira 2018-09-11T20_46_22+0800.html
          113 kB
        4. PUBLIC-23.xml 2019-11-25 15-50-08.png
          PUBLIC-23.xml 2019-11-25 15-50-08.png
          288 kB
        5. screenshot-1.png
          screenshot-1.png
          58 kB
        6. screenshot-2.png
          screenshot-2.png
          205 kB
        7. Screen Shot 2019-11-25 at 3.49.19 pm.png
          Screen Shot 2019-11-25 at 3.49.19 pm.png
          287 kB
        8. screenshot-3.png
          screenshot-3.png
          66 kB

            [JSDSERVER-6118] The SLA information is not included in the Excel and HTML export

            Antonio D'Errico added a comment -

            hi,

            in the version 8.1 the sla values are there but the icons are missing so this is not resolved.

             

            Antonio D'Errico added a comment - hi, in the version 8.1 the sla values are there but the icons are missing so this is not resolved.  

            Pawel Drygas (Inactive) added a comment -

            Hey all,

            The HTML export seems to include the SLA information, but the Excel export was removed on purpose due to security vulnerabilities. To substitute it, CSV export was introduced which is yet to be able to include SLA data. Please watch and vote for the appropriate suggestion https://jira.atlassian.com/browse/JRASERVER-62457

            Cheers,
            Pawel, Jira Developer

            Pawel Drygas (Inactive) added a comment - Hey all, The HTML export seems to include the SLA information, but the Excel export was removed on purpose due to security vulnerabilities. To substitute it, CSV export was introduced which is yet to be able to include SLA data. Please watch and vote for the appropriate suggestion https://jira.atlassian.com/browse/JRASERVER-62457 Cheers, Pawel, Jira Developer

              lgoodhewcook Lachlan G (Inactive)
              bkek Benz Kek (Inactive)
              Affected customers:
              19 This affects my team
              Watchers:
              27 Start watching this issue

                Created:
                Updated:
                Resolved: