Versions Compared

Old Version 8

changes.mady.by.user jPlugs

Saved on

compared with

New Version 9

changes.mady.by.user jPlugs

Saved on

Key

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

...

JQL Functions

See JQL Functions

Alias Searching

Available app version 2.3.5.

SLA Issue Properties can be searched using alias names making it faster and more intuitive to search for issues with SLA Values.

AliasKeyTypeValueDescription

slaStringanyThe id of the current or last used SLA
slaOnslaonStringtrue/false

Whether or not the issue is in scope of a SLA

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


slaNameslanameStringanyThe name of the current or last used SLA

slatimeNumberA positive integerThe SLA Target Time in seconds
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



statusString

Any value that matches

the id of a SLA Status

The id of the current SLA Status.
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



forcedstate.stateNumber0 or 1

If the issue is paused the value will be 1. Otherwise empty or 0

Since version 1.5.0


forcedstate.dateisoDateA String representation of a Date

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

Since version 1.5.0


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

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


Issue Property Searching

All issue SLA Values are stored as issue properties and as such enables fast and effective JQL searching.

...