We need scriptrunner script to retrieve "Time to first response"

unknown

We need to figure out "Time to first response" and below are the details about jira details and custom field value that we are getting. Can you please suggest the logic that we need to write from this custom field value to retrieve the same:-

1) JIRA# SPSDT-68 (https://dev-jira.lamresearch.com/browse/SPSDT-68\)
2) On UI it shows #
-8mon
3) Custom field value that we are getting is below:-
SLAValue{completeSLAData=[], timeline=Timeline{events=[TimelineEvent

{date=2022-02-09T08:44:36.389Z, types=[START]}

]}, ongoingSLAData=OngoingSLAData{goalId=60, startTime=2022-02-09T08:44:36.389Z, paused=false, thresholdData=some(ThresholdData

{calculatedAt=2022-02-13T08:44:36.440Z, remainingTime=some(-338400051), thresholdsConfigChangeDate=2021-03-19T13:58:30.300Z, thresholdsConfigChangeMsEpoch=1616162310301}

)}, metricId=24, definitionChangeDate=1970-01-01T00:00:00.000Z, definitionChangeMsEpoch=0, goalsChangeDate=2021-04-30T18:23:16.240Z, goalsChangeMsEpoch=1619806996239, goalTimeUpdatedDate=2021-04-30T18:23:16.200Z, goalTimeUpdatedMsEpoch=1619806996199, metricCreatedDate=1616162310301, updatedDate=some(1644741876456)}

For the other jira the custom field value we are getting is different as explained below:-
1) JIRA# SPSDT-69(https://dev-jira.lamresearch.com/browse/SPSDT-69\)
2) On UI it shows #
-1mon
3) Custom field value that we are getting is below:-
SLAValue{completeSLAData=[CompleteSLAData{calendarName=Default 24/7 calendar, succeeded=false, goalTime=7200000, goalTimeUnits=some(SLAGoalRemainingTimeUnits

{weeks=0, remainingDaysWithinWeek=0, remainingMillisWithinDay=7200000, breached=false}

), elapsedTime=4930727580, remainingTime=some(-4923527580), remainingTimeUnits=some(SLAGoalRemainingTimeUnits

{weeks=7, remainingDaysWithinWeek=6, remainingMillisWithinDay=171527580, breached=true}

), startTime=2022-02-14T16:56:35.453Z, stopTime=2022-04-12T18:35:23.033Z}], timeline=Timeline{events=[TimelineEvent

{date=2022-02-14T16:56:35.453Z, types=[START]}

, TimelineEvent

{date=2022-04-12T18:35:23.033Z, types=[STOP]}

]}, ongoingSLAData=null, metricId=24, definitionChangeDate=1970-01-01T00:00:00.000Z, definitionChangeMsEpoch=0, goalsChangeDate=null, goalsChangeMsEpoch=null, goalTimeUpdatedDate=null, goalTimeUpdatedMsEpoch=null, metricCreatedDate=1616162310301, updatedDate=some(1649788524423)}

Can you suggest a logic for retrieving "Time to first response".

Ram Kumar Aravindakshan _Adaptavist_

Hi @[deleted]

For your requirement, you will need to use the REST Endpoint to invoke the SLA from the Service Desk's REST Service and need to filter the result with something like:-

import com.atlassian.jira.component.ComponentAccessor
import com.onresolve.scriptrunner.runner.rest.common.CustomEndpointDelegate
import groovy.json.JsonBuilder
import groovy.transform.BaseScript
import groovyx.net.http.HttpResponseDecorator
import groovyx.net.http.RESTClient
import javax.servlet.http.HttpServletRequest
import javax.ws.rs.core.MultivaluedMap
import javax.ws.rs.core.Response

@BaseScript CustomEndpointDelegate delegate
getTimeToFirstResponse { MultivaluedMap queryParams, body, HttpServletRequest request ->
    def issueKey = queryParams.getFirst('issueKey')

    def applicationProperties = ComponentAccessor.applicationProperties

    final def baseUrl = applicationProperties.getString('jira.baseurl')
    final def username = 'admin'
    final def password = 'q'
    final def headers = ['Authorization': "Basic ${"${username}:${password}".bytes.encodeBase64()}",
'X-ExperimentalApi': 'opt-in', 'Accept': 'application/json'] as Map

    def http = new RESTClient(baseUrl)
    http.setHeaders(headers)

    def resp = http.get(path: "/rest/servicedeskapi/request/${issueKey}/sla") as HttpResponseDecorator

if (resp.status != 200) {
        log.warn 'Commander did not respond with 200 for retrieving project list'
    }

    def issueJson = resp.data as Map

    def totalValues = issueJson['values'] as List<Map>

    def result = totalValues.findAll {it['name'] == 'Time to first response'}

    def time =  result['ongoingCycle']['startTime']['jira']

    Response.ok(new JsonBuilder(time).toPrettyString()).build()
}

Please note that the sample code provided is not 100% exact to your environment. Hence, you will need to make the required modifications. 

Below is a screenshot filtered result that is returned:-

Below is a screenshot of the REST Endpoint configuration:-

Once you have obtained the result, you can pass the value to a Behaviour or Listener or whatever you want to use to invoke it.

I hope this helps to solve your question. :-)

Thank you and Kind regards,

Ram