Page Comparison

...

slatimeNumberThe SLA Target Time in seconds

Alias

Key

Type

Value

Description

sla

String

any

The id of the current or last used SLA

slaOn

slaon

String

true/false

Whether or not the issue is in the scope of a SLA

Code Block

language	sql

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

slaName

slaname

String

any

The name of the current or last used SLA

Code Block

language

A positive integer

sql

slaName = "p1"

slaSpentTime

time

Number

A positive integer

The Time Spent in seconds

Code Block

language	sql

slaSpentTime < slaToTime(2h)
slaSpentTime < slaToTime("2h 8m 2s")
slaSpentTime < slaToTime(02:08:02)
slaSpentTime < 7682

status

String

Any value that matches

the id of a SLA Status

The id of the current SLA Status.

slaDate

dateiso

Date

A String representation of a Date

The time and date of when SLA Values was updated by the Add-on

Code Block

language	sql

slaDate > 2020-01-01
slaDate > startOfMonth()
slaDate > -1h

slaETA

etaiso

Date

A String representation of a Date

The time and date of when the issue should be completed with current SLA - The Target Date.

Code Block

language	sql

slaDate > 2020-01-01
slaDate > startOfMonth()
slaDate > -1h

forcedstate.stateslaPause

Numberpause

0 or 1

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

Since version 1.5.0

forcedstate.dateiso

Date

A String representation of a Date

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

Since version 1.5.0

percent

Number

A positive integer

The percent value of Time Spent compared to the SLA Target Time

customslatime

String

true/false

Whether or not the issue has a custom SLA Target Time (The SLA Target Time has been overriden)

frstatus

String

AHEAD, BEHIND, OK or DELAYED

The id of the current First Response Status

frtime

Number

A positive integer

The time spent before First Response was initiated

frslatime

Number

A positive integer

The SLA First Response Target Time in secondsString

"Paused" or "Not Paused"

Code Block

language	sql

slaPaused = "Paused"
slaPaused != "Paused"
slaPaused = "Not Paused"
slaPaused = slaIsPaused()
slaPaused != slaIsPaused()

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

...

Code Block

language	java

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.

Key	Type	Value	Description
sla	String	any	The id of the current or or last used SLA
slaon	String	true/false	Whether or not the issue is in scope of a SLA
slaname	String	any	The name of the current or last used SLA
slatime	Number	A positive integer	The SLA Target Time in seconds
time	Number	A positive integer	The Time Spent in seconds
status	String	Any value that matches the id of a SLA Status	The id of the current SLA Status.
dateiso	Date	A String representation of a Date	The time and date of when SLA Values was updated by the Add-on
etaiso	Date	A String representation of a Date	The time and date of when the issue should be completed with current SLA - The Target Date.
forcedstate.statepaused	NumberString	0 "Paused" or 1null	If the issue is paused the value will be 1is "Paused". Otherwise empty or 0null. Since version 12.3.5.0
forcedstate.dateisopauseddateiso	Date	A String representation of a Date	The time and date of when this issue was paused (if paused) Since version 12.3.5.0
percent	Number	A positive integer	The percent value of Time Spent compared to the SLA Target Time
customslatime	String	true/false	Whether or not the issue has a custom SLA Target Time (The SLA Target Time has been overriden)
frstatus	String	AHEAD, BEHIND, OK or DELAYED	The id of the current First Response Status
frtime	Number	A positive integer	The time spent before First Response was initiated
frslatime	Number	A positive integer	The SLA First Response Target Time in seconds
issueid	Number	Long	The issue id
projectid	Number	Long	The issue project id

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

...

Versions Compared

Old Version 9

New Version 10

Key

SLA Values