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 current SLA - The Target Date.

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


slaPausepauseString"Paused" or "Not Paused"


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


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

...