Versions Compared

Old Version 9

changes.mady.by.user jPlugs

Saved on

compared with

New Version Current

changes.mady.by.user jPlugs

Saved on

Key

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

The add-on enables precise and accurate searching for SLA issues.

JQL Functions

See JQL Functions

Alias Searching

Available app version 2.3.5.

...

slatimeNumberThe SLA Target Time in seconds
AliasKeyTypeValueDescriptionslaString
anyThe id of the current or last used SLAslaOnslaonStringtrue/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
language
A positive integer
sql
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
statusString

Any value that matches
the id of a SLA Status
The id of the current SLA Status.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 the 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.dateisoDate

A String 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 
 time and 
 date of when 
 this 
the issue was paused
 (if paused)
Since version 1.5.0
percentNumberA positive integerThe percent value of Time Spent compared to the SLA Target TimecustomslatimeStringtrue/falseWhether or not the issue has a custom SLA Target Time (The SLA Target Time has been overriden)
.
 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,
 OK or DELAYEDThe id of the current First Response Status
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 
 spent before First Response was initiated		frslatimeNumberA positive integerThe SLA First Response Target Time in seconds
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 guarantied guaranteed 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.
...
 Code Block
languagejava
issue.property[slatimer].sla in slaName("P1","P2:) //issue with a sla named p1 or P2
issue.property[slatimer].slaname = "p1" //issuea with a sla named p1
issue.property[slatimer].time = 3600 //spent time is equal to 1 hour = 3600 seconds
issue.property[slatimer].time = slaToSecons("1h") //spent time is equal to 1 hour = 3600 seconds
issue.property[slatimer].etaiso > now() //target date less than current date and time
issue.property[slatimer].forcedstate.statepaused = 1"Paused"  //issue is paused issues

SLA Values
The SLA Values are the values the Add-on stores for an issue.
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.
forcedstate.statepausedNumberString0 or 1"Paused" or "Not Paused"
If the issue is paused the value will be 1is "Paused". Otherwise empty or 0null.
Since version 12.3.5.0
forcedstate.dateisopauseddateisoDateA String representation of a Date
The time and date of when this issue was paused (if paused)
Since version 12.3.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
issueidNumberLongThe issue id
projectidNumberLongThe issue project id
It is not guarantied guaranteed that an issue will contain all property keys.
...