Versions Compared

Old Version 13

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.

...

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

String

AHEAD, BEHIND,

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 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 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].paused = "Paused"  //issue is paused


SLA Values

The SLA Values are the values the Add-on stores for an issue.

...