Details
-
Bug
-
Status: Closed
-
Major
-
Resolution: Fixed
-
4.3.1
-
R5.1.0 Sprint 3, R5.6.0 Sprint 1
-
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!