Versions Compared

Old Version 11

changes.mady.by.user jPlugs

Saved on

compared with

New Version 12

changes.mady.by.user jPlugs

Saved on

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


slaPauseslaPausedpause

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*/


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

...