JIRA "sprint" changed its data

Making Packs
1

Hi,

It seems that JIRA pack was updated, once “Sprint” field doesn’t bring the raw json anymore.
Before, I was using RegexReplace to identify a CLOSED, ACTIVE or FUTURE sprint (besides other details).
Now, field comes with the following information:

"

{
“Goal”:“Sprint para finalizar em 30/07/2019”,
“Name”:“Product Development - 30/07/19”,
“EndDate”:{
“type”:“dt”,
“epoch”:1564540560,
“input”:“7/30/2019 11:36 PM”
},
“StartDate”:{
“type”:“dt”,
“epoch”:1563331015.255,
“input”:“7/16/2019 11:36:55 PM”
},
“CompleteDate”:{
“type”:“dt”,
“epoch”:1564540558.804,
“input”:“7/30/2019 11:35:58 PM”
}
},
{
“Goal”:“Sprint para finalizar em 13/08/19”,
“Name”:“Product Development - 13/08/19”,
“EndDate”:{
“type”:“dt”,
“epoch”:1565750160,
“input”:“8/13/2019 11:36 PM”
},
“StartDate”:{
“type”:“dt”,
“epoch”:1564540607.795,
“input”:“7/30/2019 11:36:47 PM”
},
“CompleteDate”:{
“type”:“dt”,
“epoch”:1565751183.988,
“input”:“8/13/2019 11:53:03 PM”
}
}
}
"

There’s no “sprint state” anymore, and I’ll have to change a little bit what I do internally (quite a big impact on my reports).
Anyone else faced it? Any quick workarounds?

2

Partial solution that I created so far for “Sprint status” identification:
(sorry for lack of identation in the code - terrible one)

if(IsBlank(thisRow.Sprint) AND thisRow.Status != "Done",
   "Backlog",
   if(thisRow.Sprint.Name.Count() > 1,
  If(thisRow.Sprint.Name.Count() = thisRow.Sprint.CompleteDate.Count() OR thisRow.Sprint.CompleteDate.Last().Length()>0,If(thisRow.Status="Done","CLOSED","Backlog"),
     if(thisRow.Sprint.CompleteDate.Last().Length() > 0,
        If(thisRow.Status="Done","CLOSED","Backlog"),
         If(thisRow.Sprint.Last().EndDate.Length()>0,"ACTIVE","FUTURE")    
  ) 
  ),
  if(thisRow.Sprint.CompleteDate.Length() > 0,
      If(thisRow.Status="Done","CLOSED","Backlog"),
      If(thisRow.Sprint.EndDate.Length()>0,"ACTIVE","FUTURE")
      )
  )
)