Versions Compared

Old Version 3

changes.mady.by.user Derya Özdemir

Saved on

compared with

New Version 4

changes.mady.by.user Derya Özdemir

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

...

...

Info

This page is

...

for Time to SLA for Jira(Server) users.

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

Table of Contents
maxLevel1

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]

          <br>

          <br>
       """
     }
}
  
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>

            <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]

             <br>

             <br>
        """
    }
  
}
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]

            <br>

            <br>
       """
        }
    }
}
  
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]