Versions Compared

Old Version 12

changes.mady.by.user jPlugs

Saved on

compared with

New Version 13

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

StringAHEAD, BEHIND, DELAYED, OK

slaFirstResponseStatus = BEHIND

slaFirstResponseStatus != BEHIND

slaFirstResponseStatus is EMPTY

slaFirstResponseStatus is not EMPTY

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

...

KeyTypeValueDescription
slaStringanyThe id of the current or or last used SLA
slaonStringtrue/falseWhether or not the issue is in scope of a SLA
slanameStringanyThe name of the current or last used SLA
slatimeNumberA positive integerThe SLA Target Time in seconds
timeNumberA positive integerThe Time Spent in seconds
statusString

Any value that matches

the id of a SLA Status

The id of the current SLA Status.
dateisoDateA String representation of a DateThe time and date of when SLA Values was updated by the Add-on
etaisoDateA String representation of a DateThe time and date of when the issue should be completed with current SLA - The Target Date.
pausedString"Paused" or null"Not Paused"

If the issue is paused the value is "Paused". Otherwise null.

Since version 2.3.5

pauseddateisoDateA String representation of a Date

The time and date of when this issue was paused (if paused)

Since version 2.3.5

percentNumberA positive integerThe percent value of Time Spent compared to the SLA Target Time
customslatimeStringtrue/falseWhether or not the issue has a custom SLA Target Time (The SLA Target Time has been overriden)
frstatusStringAHEAD, BEHIND, OK or DELAYEDThe id of the current First Response Status
frtimeNumberA positive integerThe time spent before First Response was initiated
frslatimeNumberA positive integerThe SLA First Response Target Time in seconds
issueidNumberLongThe issue id
projectidNumberLongThe issue project id

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

...