Versions Compared

Key

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

...

This page describes what values the different custom fields holds and gives some search examples.

See also JQL Functions

 

Field

Image Modified

TypeString
ValueAHEAD, BEHIND, OK or DELAYED
Search

"SLA First Response Status" = "BEHIND" //case sensitive

"SLA First Response Status" in slaFRStatus("behind", "ok") //case insensitive


Field

Image Modified

TypeNumber
Value

A positive integer

Seconds

Search

"SLA First Response Time" = 3600 //1hour

"SLA First Response Time" = slaToSeconds(1h59m59s) //1 hour 59 minuts and 59 seconds = 7199 seconds

"SLA First Response Time" = slaToSeconds(01:59:59) //1 hour 59 minuts and 59 seconds = 7199 seconds


Field

Image Modified

TypeDate Time
Value

Any date

Search

"SLA Target Date" > now()

"SLA Target Date" > 2d

"SLA Target Date" > "2016-01-01"


Field

Image Modified

TypeDate Time
ValueAny date
Search

"SLA Updated" > now()

"SLA Updated" > 2d

"SLA Updated" > "2016-01-01"


Field

Image Modified

TypeString
Value

"SLA Name" = "my sla"

"SLA Name" in slaName("bugs","incidents")


Field

Image Modified

TypeString
Value

ON

OFF

Search

"SLA On" = "ON"

"SLA On" = "OFF" or "SLA On" != "ON"


Field

Image Added

TypeString
Value

Paused

null / empty

Search

"SLA Paused" = "Paused" //Case sensitive. All paused issues

"SLA Paused" = slaIsPaused()  // All paused issues


"SLA Paused" is Empty //All not paused issues

"SLA Paused" != slaIsPaused()  //Do not use, use is empty statement.

SinceVersion 1.5.0


Field

Image Modified

TypeNumber
Value

An integer. Positive if issue is overdue. Negative if on time.

Seconds

Search

"SLA Over Time" = 3600 //1hour

"SLA Over Time" = slaToSeconds(1h59m59s) //1 hour 59 minuts and 59 seconds = 7199 seconds

"SLA Over Time" = slaToSeconds(01:59:59) //1 hour 59 minuts and 59 seconds = 7199 seconds


Field

Image Modified

 

TypeNumber
ValueA positive integer
Search

"SLA Percent" > 0

"SLA Percent" < 100

"SLA Percent" >= 100


Field

Image Modified

TypeString
Value

Any string value that equals a SLA status label.

Default are "ON TIME", "LATE", "OVERDUE" and "OVERDUE+"

Search

"SLA Status" = "LATE" //case sensitive

"SLA Status" in slaStatus("late", "on time") //case insensitive


Field

Image Modified

TypeNumber
Value

A positive integer

Seconds

Search

"SLA Time Spent" = 3600 //1hour

"SLA Time Spent" = slaToSeconds(1h59m59s) //1 hour 59 minuts and 59 seconds = 7199 seconds

"SLA Time Spent" = slaToSeconds(01:59:59) //1 hour 59 minuts and 59 seconds = 7199 seconds