Versions Compared

Key

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

...

AliasKeyTypeValueDescription
slaOnslaonStringtrue/false

Whether or not the issue is in the scope of a SLA

Code Block
languagesql
slaOn = "true"
slaOn = "false"
slaOn is Empty
slaOn in slaIsOn()
slaOn not in slaIsOn()


slaNameslanameStringany

The name of the current or last used SLA

Code Block
languagesql
slaName = "p1"


slaSpentTimetimeNumberA positive integer

The Time Spent in seconds

Code Block
languagesql
slaSpentTime < slaToTime(2h)
slaSpentTime < slaToTime("2h 8m 2s")
slaSpentTime < slaToTime(02:08:02)
slaSpentTime < 7682


slaDatedateisoDateA string representation of a Date

The time and date of when SLA Values was updated by the Add-on

Code Block
languagesql
slaDate > 2020-01-01
slaDate > startOfMonth()
slaDate > -1h


slaETAetaisoDateA string representation of a Date

The time and date of when the issue should be completed with the current SLA - The Target Date.

Code Block
languagesql
slaDate > 2020-01-01
slaDate > startOfMonth()
slaDate > -1h


slaPaused

paused

String"Paused" or "Not Paused"


Code Block
languagesql
slaPaused = "Paused"
slaPaused != "Paused"
slaPaused = "Not Paused"
slaPaused = slaIsPaused()
slaPaused != slaIsPaused()


slaPausedDate

pauseddateiso

StringA string representation of a Date

The date of when the issue was paused.

Code Block
languagesql
slaPausedDate > -2h
slaPausedDate >-5h AND slaPausedDate <-2h
slaPausedDate > 2020-05-11 AND slaPausedDate < 2020-05-12
slaPausedDate  > startOfDay()  /*Paused today*/


slaIssue

issueid

NumberThe issue id (not issue key)


Code Block
languagesql
slaIssue in issueHistory()
slaIssue in updatedBy("mike")


slaFirstResponseStatus

frstatus

String

AHEAD, BEHIND,

DELAYED, OK


Code Block
languagesql
slaFirstResponseStatus = BEHIND


slaFirstResponseStatus != BEHIND


slaFirstResponseStatus is EMPTY


slaFirstResponseStatus is not EMPTY


slaFirstResponseDate

frdateiso

DateA string representation of a Date


Code Block
languagesql
slaFirstResponseDate > -2h
slaFirstResponseDate >-5h AND slaFirstResponseDate <-2h
slaFirstResponseDate > 2020-05-11 AND slaFirstResponseDate < 2020-05-12
slaFirstResponseDate  > startOfDay()  /*First response today*/


slaFirstResponseTime

frtime

NumberA positive integer

The time in seconds before first response was intiated.

Code Block
languagesql
slaFirstResponseTime < slaToTime(2h)
slaFirstResponseTime < slaToTime("2h 8m 2s")
slaFirstResponseTime < slaToTime(02:08:02)
slaFirstResponseTime < 7682


It is not guaranteed that an issue will contain all property keys.

...