...

Panel

panelIconId	atlassian-info
panelIcon	:info:
bgColor	#F4F5F7

This page is about Time to SLA for Jira

...

On-Prem.

On this page, you will find Groovy scripts, which enable you to get detailed info on TTS custom fields.

Table of Contents

maxLevel	1

If you're using Script Runner Plugin, you can easily use these code snippets to get data.

Script for Time to SLA

...

Custom Field

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58

import com.atlassian.jira.component.ComponentAccessor
import com.atlassian.jira.issue.CustomFieldManager
import com.atlassian.jira.issue.MutableIssue
import com.atlassian.jira.issue.customfields.CustomFieldType
import com.atlassian.jira.issue.fields.CustomField
import java.util.*
import java.text.SimpleDateFormat
import java.sql.Timestamp

// get CustomFieldManager instance
def customFieldManager = ComponentAccessor.getCustomFieldManager()
// find your TTS custom field's ID and put it here instead of 10600
def ttsField = customFieldManager.getCustomFieldObject("customfield_10600")
// get custom field value object
def ttsFieldValue = issue.getCustomFieldValue(ttsField)
// date/time formatter will be used to format date attributes
def formatter =

new

new SimpleDateFormat("MM/dd/yyyy HH:mm:ss")
// all attributes will be stored to result variable
def result = ""
// TTS custom field returns list, let's iterate
if (ttsFieldValue && ttsFieldValue.size()

> 0

> 0) {

ttsFieldValue

ttsFieldValue.each {

String

String slaName = it.slaName

int

int slaValueAsMinutes = it.slaValue

String

String slaValueAsTimeString = it.slaValueAsString

String

String originStatusName = it.originStatusName

String

String targetStatusName = it.targetStatusName

Date

Date originDate = it.statusDate

Date

Date expectedTargetDate = it.slaTargetDate

Date

Date actualTargetDate = it.untilDate

long

long timeLeftTillSla = it.

timeToSla

timeToSla // if less than 0, overdue

String

String timeLeftTillSlaAsTimeString = it.

timeToSlaAsString

timeToSlaAsString // if there is overdue, overdue string

boolean

boolean isPaused = it.paused

boolean

boolean startDateProvidedByDateCustomField = it.startDateProvidedByDateCustomField

boolean

boolean endDateProvidedByDateCustomField = it.endDateProvidedByDateCustomField

boolean

boolean negotiationDateProvidedByDateCustomField = it.negotiationDateProvidedByDateCustomField

result

       result = """
          [SLA Name: $slaName]
          [SLA Value As Minutes: $slaValueAsMinutes]
          [SLA Value As Time String: $slaValueAsTimeString]
          [Origin Status: $originStatusName]
          [Target Status: $targetStatusName]
          [Origin Date: ${formatter.format(originDate)}]
          [Expected Target Date: ${expectedTargetDate ? formatter.format(expectedTargetDate) : 'Not yet defined'}]
          [Actual Target Date: ${actualTargetDate ? formatter.format(actualTargetDate) : 'Not yet'}]
          [Time Left Till

SLA as

SLA as milis: $timeLeftTillSla]
[Time Left Till

SLA

SLA as

as

Time String: $timeLeftTillSlaAsTimeString]
[Is

SLA

SLA in

in

Paused Status: $isPaused]
          [Is Start Date Provided By Date Custom Field: $startDateProvidedByDateCustomField]
          [Is End Date Provided By Date Custom Field: $endDateProvidedByDateCustomField]
          [Is Negotiation Date Provided By Date Custom Field: $negotiationDateProvidedByDateCustomField]

 

 
 """
 }
}

result.toString()

Sample Result
`[SLA Name: Sla to Resolution]` `[SLA Value As Minutes: 240]` `[SLA Value As Time String: 4h]` `[Origin Status: Open]` `[Target Status: Resolved]` `[Origin Date: 06/13/2016` `09:33:30]` `[Expected Target Date: 06/13/2016` `13:33:30]` `[Actual Target Date: Not yet]` `[Time Left Till SLA as milis: -34676000]` `[Time Left Till SLA as Time String: - 9 hours, 37 minutes, 56 seconds]` `[Is`

SLA in

SLA in Paused Status:

false

false]
[Is Start Date Provided By Date Custom Field:

false

false]
[Is End Date Provided By Date Custom Field:

false

false]
[Is Negotiation Date Provided By Date Custom Field:

false

false]

...

Script for SLA Overview

...

Custom Field

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58

import com.atlassian.jira.component.ComponentAccessor
import com.atlassian.jira.issue.CustomFieldManager
import com.atlassian.jira.issue.MutableIssue
import com.atlassian.jira.issue.customfields.CustomFieldType
import com.atlassian.jira.issue.fields.CustomField
import java.util.*
import java.text.SimpleDateFormat
import java.sql.Timestamp

// get CustomFieldManager instance
def customFieldManager = ComponentAccessor.getCustomFieldManager()
// find your SLA Overview field's ID and put it here instead of 10801
def overviewField = customFieldManager.getCustomFieldObject("customfield_10801")
def overviewFieldValue = issue.getCustomFieldValue(overviewField)
// date/time formatter will be used to format date attributes
def formatter = new

new

SimpleDateFormat("MM/dd/yyyy HH:mm:ss")
def returnString = ""
// SLA Overview field returns list
if (overviewFieldValue && overviewFieldValue.size()

> 0

> 0) {
// if there is overdue, then all details of overdues are in 'overdues' attribute

overviewFieldValue

overviewFieldValue.each {

String

String slaName = it.slaName

def

def slaStatus = it.status

int

int slaValueAsMinutes = it.slaValueAsMinutes

String

String slaValueAsTimeString = it.slaValueAsTimeString

Date

Date originDate = it.originDate

Date

Date expectedTargetDate = it.expectedTargetDate

Date

Date actualTargetDate = it.actualTargetDate

String

String workingDurationAsTimeString = it.workingDuration

long

long workingDurationAsSeconds = it.workingDurationAsSeconds

String

String pausedDurationAsTimeString = it.pausedDuration
// if there is overdue

String

String overdueString = it.breachString

int

int originStatusId = it.sla.originStatusId // next-gen slas doesn't have this field

int

int targetStatusId = it.sla.targetStatusId // next-gen slas doesn't have this field

boolean

boolean negotiationDateProvidedByCustomField = it.negotiationDateProvidedByCustomField

returnString

       returnString += """
              [SLA Name: $slaName]
              [SLA Status: $slaStatus]
              [SLA Value As Minutes: $slaValueAsMinutes]
              [SLA Value As Time String: $slaValueAsTimeString]
            [Origin Date: ${formatter.format(originDate)}]
            [Expected Target Date: ${expectedTargetDate ? formatter.format(expectedTargetDate) : 'Not yet defined'}]
              [Actual Target Date: ${actualTargetDate ? formatter.format(actualTargetDate) : 'Not yet'}]
            [Working Duration: $workingDurationAsTimeString]
            [Working Duration As Seconds: $workingDurationAsSeconds]
            [Paused Duration: $pausedDurationAsTimeString]
            [Overdue: $overdueString]
            [Origin Status Id: $originStatusId]
            [Target Status Id: $targetStatusId]
            [Is Negotiation Date Provided By Custom Field: $negotiationDateProvidedByCustomField]

 

`<br>` `"""` `}` `}` `returnString.toString()`

Sample Result

[SLA Name: Sla to Resolution]
[SLA Status: EXCEED]
[SLA Value As Minutes: 240]
[SLA Value As Time String: 4h]
[Origin Date: 06/13/2016 09:33:30]
[Expected Target Date: 06/13/2016 13:33:30]
[Actual Target Date: Not yet]
[Working Duration: 8 hours, 23 minutes, 16 seconds]
[Working Duration As Seconds: 51796]
[Paused Duration: 0]
[Overdue: 4 hours, 23 minutes, 16 seconds]
[Origin Status Id: 49]
[Target Status Id: 53]
[Is Negotiation Date Provided By Custom Field:

false

false]

[SLA Name: Trivial Sla]
[SLA Status: STILL]
[SLA Value As Minutes: 1440]
[SLA Value As Time String: 1d]
[Origin Date: 06/13/2016 09:33:30]
[Expected Target Date: 06/14/2016 23:54:28]
[Actual Target Date: Not yet]
[Working Duration: 10 minutes]
[Working Duration As Seconds: 600]
[Paused Duration: 1 hour, 13 minutes, 16 seconds]
[Overdue: null]
[Origin Status Id: 49]
[Target Status Id: 54]
[Is Negotiation Date Provided By Custom Field:

false

false]

...

Script for Overdue

...

Custom field

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51

import com.atlassian.jira.component.ComponentAccessor
import com.atlassian.jira.issue.CustomFieldManager
import com.atlassian.jira.issue.MutableIssue
import com.atlassian.jira.issue.customfields.CustomFieldType
import com.atlassian.jira.issue.fields.CustomField
import java.util.*
import java.text.SimpleDateFormat
import java.sql.Timestamp

def customFieldManager = ComponentAccessor.getCustomFieldManager()
// find your Overdue Status custom field's ID and put it here instead of 10601
def overdueField = customFieldManager.getCustomFieldObject("customfield_10601")
def overdueFieldValue = issue.getCustomFieldValue(overdueField)
def formatter =

new

new SimpleDateFormat("MM/dd/yyyy HH:mm:ss")
def result = ""
// overdue field returns list
if (overdueFieldValue && overdueFieldValue.size()

> 0

> 0) {

overdueFieldValue

overdueFieldValue.each {

String

String slaName = it.description

int

int slaValueAsMinutes = it.slaValue

String

String slaValueAsTimeString = it.slaValueAsString

String

String originStatusName = it.beforeState

String

String targetStatusName = it.afterState

Date

Date originDate = it.beforeDate

Date

Date expectedTargetDate = it.expectedTargetDate

Date

Date actualTargetDate = it.afterDate

long

long workingTimeAsMillis = it.workingTimeAsMillis

String

String overdue = it.overdue

boolean

boolean startDateProvidedByDateCustomField = it.startDateProvidedByDateCustomField

boolean

boolean endDateProvidedByDateCustomField = it.endDateProvidedByDateCustomField

boolean

boolean negotiationDateProvidedByDateCustomField = it.negotiationDateProvidedByDateCustomField

result

        result = """
            [SLA Name: $slaName]
            [SLA Value As Minutes: $slaValueAsMinutes]
            [SLA Value As Time String: $slaValueAsTimeString]
            [Origin Status: $originStatusName]
            [Target Status: $targetStatusName]
            [Origin Date: ${formatter.format(originDate)}]
            [Expected Target Date: ${expectedTargetDate ? formatter.format(expectedTargetDate) : 'Not yet defined'}]
            [Actual Target Date: ${actualTargetDate ? formatter.format(actualTargetDate) : 'Not yet'}]
            [Overdue: ${overdue}]
            [Is Start Date Provided By Date Custom Field: $startDateProvidedByDateCustomField]
            [Is End Date Provided By Date Custom Field: $endDateProvidedByDateCustomField]
            [Is Negotiation Date Provided By Date Custom Field: $negotiationDateProvidedByDateCustomField]

 

 
 """
 }

}
result.toString()

Sample Result
`[SLA Name: Sla ro Resolution]` `[SLA Value As Minutes: 240]` `[SLA Value As Time String: 4h]` `[Origin Status: Open]` `[Target Status: Resolved]` `[Origin Date: 06/13/2016` `12:27:32]` `[Expected Target Date: 06/13/2016` `16:27:32]` `[Actual Target Date: 06/13/2016` `18:28:49]` `[Overdue: 2 hours, 1 minute, 17 seconds]` `[Is Start Date Provided By Date Custom Field:`

false

false]
[Is End Date Provided By Date Custom Field:

false

false]
[Is Negotiation Date Provided By Date Custom Field:

false

false]

...

Script for SLA Indicator

...

Custom Field

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59

import com.atlassian.jira.component.ComponentAccessor
import com.atlassian.jira.issue.CustomFieldManager
import com.atlassian.jira.issue.MutableIssue
import com.atlassian.jira.issue.customfields.CustomFieldType
import com.atlassian.jira.issue.fields.CustomField
import java.util.*
import java.text.SimpleDateFormat
import java.sql.Timestamp

def customFieldManager = ComponentAccessor.getCustomFieldManager()
// find your SLA Indicator field's ID and put it here instead of 10700
def indicatorField = customFieldManager.getCustomFieldObject("customfield_10700")
def indicatorFieldValue = issue.getCustomFieldValue(indicatorField)
def formatter =

new

new SimpleDateFormat("MM/dd/yyyy HH:mm:ss")
def returnString = ""
// SLA Indicator field returns an object
if (indicatorFieldValue) {

String

    String result = indicatorFieldValue.result

    // if there is overdue, then all details of overdues are in 'overdues' attribute

def

def overdues = indicatorFieldValue.overdues

if

if (overdues.size()

> 0

> 0) {

overdues

overdues.each {

def

def overdue = it.value

String

String slaName = overdue.slaName

int

int slaValueAsMinutes = overdue.slaValueAsMinutes

String

String slaValueAsTimeString = overdue.slaValueAsTimeString

Date

Date originDate = overdue.originDate

Date

Date expectedTargetDate = overdue.expectedTargetDate

Date

Date actualTargetDate = overdue.actualTargetDate

String

String workingDurationAsTimeString = overdue.workingDuration

long

long workingDurationAsSeconds = overdue.workingDurationAsSeconds

String

String pausedDurationAsTimeString = overdue.pausedDuration

String

String overdueString = overdue.breachString

int

int originStatusId = overdue.sla.originStatusId // next-gen slas don't have this field

int

int targetStatusId = overdue.sla.targetStatusId // next-gen slas don't have this field

boolean

boolean negotiationDateProvidedByCustomField = overdue.negotiationDateProvidedByCustomField

returnString

       returnString = """
              [SLA Name: $slaName]
              [SLA Value As Minutes: $slaValueAsMinutes]
              [SLA Value As Time String: $slaValueAsTimeString]
            [Origin Date: ${formatter.format(originDate)}]
            [Expected Target Date: ${expectedTargetDate ? formatter.format(expectedTargetDate) : 'Not yet defined'}]
              [Actual Target Date: ${actualTargetDate ? formatter.format(actualTargetDate) : 'Not yet'}]
            [Working Duration: $workingDurationAsTimeString]
            [Working Duration As Seconds: $workingDurationAsSeconds]
            [Paused Duration: $pausedDurationAsTimeString]
            [Overdue: $overdueString]
            [Origin Status Id: $originStatusId]
            [Target Status Id: $targetStatusId]
            [Is Negotiation Date Provided By Custom Field: $negotiationDateProvidedByCustomField]

 

 
 """
 }
 }
}

returnString.toString()

Sample Result

[SLA Name: Sla to Resolution]
[SLA Value As Minutes: 240]
[SLA Value As Time String: 4h]
[Origin Date: 06/13/2016 09:33:30]
[Expected Target Date: 06/13/2016 13:33:30]
[Actual Target Date: Not yet]
[Working Duration: 14 hours, 3 minutes, 10 seconds]
[Working Duration As Seconds: 50590]
[Paused Duration: 0]
[Overdue: 10 hours, 3 minutes, 10 seconds]
[Origin Status Id: 49]
[Target Status Id: 53]
[Is Negotiation Date Provided By Custom Field:

false

false]

Versions Compared

Old Version 2

New Version Current

Key

Script for Time to SLA

Custom Field

Script for SLA Overview

Custom Field

Script for Overdue

Custom field

Script for SLA Indicator

Custom Field

Page Comparison

Versions Compared

Old Version 2

New Version Current

Key

Script for Time to SLA

Custom Field

Script for SLA Overview

Custom Field

Script for Overdue

Custom field

Script for SLA Indicator

Custom Field