Uploaded image for project: 'Xporter for Jira'
  1. Xporter for Jira
  2. XPORTER-873

Trouble with SLA custom fields in excel export

    XporterXMLWordPrintable

    Details

    • Sprint:
      R5.1.0 Sprint 3, R5.6.0 Sprint 1
    • Story Points:
      2
    • Requirement Status:

      Release 5.6.0 - OK

      Description

      Hi Xpand-team

      I'm having some trouble with integrating SLA Custom Fields into a template.
      If you reference a SLA Custom Field in an excel export you receive something like this:

      _SLAValue{completeSLAData=[CompleteSLAData

      {calendarName=Schedule 4/5 9-17 Mo-Fr, succeeded=true, goalTime=86400000, elapsedTime=3515590, startTime=2016-10-11T11:40:29.341Z, stopTime=2016-10-11T12:39:04.931Z}

      ], timeline=Timeline{events=[TimelineEvent

      {date=2016-10-11T11:40:29.341Z, types=[START]}

      , TimelineEvent

      {date=2016-10-11T12:39:04.931Z, types=[STOP]}

      ]}, ongoingSLAData=null, metricId=8, definitionChangeDate=2016-02-16T13:47:58.000Z, definitionChangeMsEpoch=1455630478290, goalsChangeDate=null, goalsChangeMsEpoch=null, goalTimeUpdatedDate=null, goalTimeUpdatedMsEpoch=null, metricCreatedDate=0}_

      The field contains all relevant information but in a not very user friendly way. Would there be a way to render these fields like JIRA does? I tried to work with some excel functions but this did not work properly.

      Thank you for your help!

        Attachments

          Activity

            People

            • Assignee:
              tfsi Tiago Silva
              Reporter:
              c.brause Carola Brause
            • Votes:
              2 Vote for this issue
              Watchers:
              10 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                Time Tracking

                Estimated:
                Original Estimate - 2 days
                2d
                Remaining:
                Time Spent - 1 day, 5 hours, 30 minutes Remaining Estimate - 2 hours, 30 minutes
                2h 30m
                Logged:
                Time Spent - 1 day, 5 hours, 30 minutes Remaining Estimate - 2 hours, 30 minutes
                1d 5h 30m