Groovy scripts for TTS fields
- Derya Özdemir
This page is about Time to SLA for Jira Data Center.
On this page, you will find Groovy scripts, which enable you to get detailed info on TTS custom fields. If you're using Script Runner Plugin, you can easily use these code snippets to get data.
Script for Time to SLA custom field
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 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) {
ttsFieldValue.each {
String slaName = it.slaName
int slaValueAsMinutes = it.slaValue
String slaValueAsTimeString = it.slaValueAsString
String originStatusName = it.originStatusName
String targetStatusName = it.targetStatusName
Date originDate = it.statusDate
Date expectedTargetDate = it.slaTargetDate
Date actualTargetDate = it.untilDate
long timeLeftTillSla = it.timeToSla // if less than 0, overdue
String timeLeftTillSlaAsTimeString = it.timeToSlaAsString // if there is overdue, overdue string
boolean isPaused = it.paused
boolean startDateProvidedByDateCustomField = it.startDateProvidedByDateCustomField
boolean endDateProvidedByDateCustomField = it.endDateProvidedByDateCustomField
boolean negotiationDateProvidedByDateCustomField = it.negotiationDateProvidedByDateCustomField
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 milis: $timeLeftTillSla]
[Time Left Till SLA as Time String: $timeLeftTillSlaAsTimeString]
[Is SLA 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>
"""
}
}
result.toString()Sample Result |
|---|
|
Script for SLA Overview custom field
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 SimpleDateFormat("MM/dd/yyyy HH:mm:ss")
def returnString = ""
// SLA Overview field returns list
if (overviewFieldValue && overviewFieldValue.size() > 0) {
// if there is overdue, then all details of overdues are in 'overdues' attribute
overviewFieldValue.each {
String slaName = it.slaName
def slaStatus = it.status
int slaValueAsMinutes = it.slaValueAsMinutes
String slaValueAsTimeString = it.slaValueAsTimeString
Date originDate = it.originDate
Date expectedTargetDate = it.expectedTargetDate
Date actualTargetDate = it.actualTargetDate
String workingDurationAsTimeString = it.workingDuration
long workingDurationAsSeconds = it.workingDurationAsSeconds
String pausedDurationAsTimeString = it.pausedDuration
// if there is overdue
String overdueString = it.breachString
int originStatusId = it.sla.originStatusId // next-gen slas doesn't have this field
int targetStatusId = it.sla.targetStatusId // next-gen slas doesn't have this field
boolean negotiationDateProvidedByCustomField = it.negotiationDateProvidedByCustomField
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 |
|---|
|
Script for Overdue custom field
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 SimpleDateFormat("MM/dd/yyyy HH:mm:ss")
def result = ""
// overdue field returns list
if (overdueFieldValue && overdueFieldValue.size() > 0) {
overdueFieldValue.each {
String slaName = it.description
int slaValueAsMinutes = it.slaValue
String slaValueAsTimeString = it.slaValueAsString
String originStatusName = it.beforeState
String targetStatusName = it.afterState
Date originDate = it.beforeDate
Date expectedTargetDate = it.expectedTargetDate
Date actualTargetDate = it.afterDate
long workingTimeAsMillis = it.workingTimeAsMillis
String overdue = it.overdue
boolean startDateProvidedByDateCustomField = it.startDateProvidedByDateCustomField
boolean endDateProvidedByDateCustomField = it.endDateProvidedByDateCustomField
boolean negotiationDateProvidedByDateCustomField = it.negotiationDateProvidedByDateCustomField
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>
"""
}
}
result.toString()Sample Result |
|---|
|
Script for SLA Indicator custom field
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 SimpleDateFormat("MM/dd/yyyy HH:mm:ss")
def returnString = ""
// SLA Indicator field returns an object
if (indicatorFieldValue) {
String result = indicatorFieldValue.result
// if there is overdue, then all details of overdues are in 'overdues' attribute
def overdues = indicatorFieldValue.overdues
if (overdues.size() > 0) {
overdues.each {
def overdue = it.value
String slaName = overdue.slaName
int slaValueAsMinutes = overdue.slaValueAsMinutes
String slaValueAsTimeString = overdue.slaValueAsTimeString
Date originDate = overdue.originDate
Date expectedTargetDate = overdue.expectedTargetDate
Date actualTargetDate = overdue.actualTargetDate
String workingDurationAsTimeString = overdue.workingDuration
long workingDurationAsSeconds = overdue.workingDurationAsSeconds
String pausedDurationAsTimeString = overdue.pausedDuration
String overdueString = overdue.breachString
int originStatusId = overdue.sla.originStatusId // next-gen slas don't have this field
int targetStatusId = overdue.sla.targetStatusId // next-gen slas don't have this field
boolean negotiationDateProvidedByCustomField = overdue.negotiationDateProvidedByCustomField
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>
"""
}
}
}
returnString.toString()Sample Result |
|---|
|