Search using Custom Fields

The add-on is shipped with a bunch of custom fields.

Custom Fields must be added to JIRA and the add-on must be configured to use the custom fields.

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

See also JQL Functions

 

Field

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

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

TypeDate Time
Value

Any date

Search

"SLA Target Date" > now()

"SLA Target Date" > 2d

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

Field

TypeDate Time
ValueAny date
Search

"SLA Updated" > now()

"SLA Updated" > 2d

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

Field

TypeString
Value

"SLA Name" = "my sla"

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

Field

TypeString
Value

ON

OFF

Search

"SLA On" = "ON"

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

Field

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

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

 

TypeNumber
ValueA positive integer
Search

"SLA Percent" > 0

"SLA Percent" < 100

"SLA Percent" >= 100

Field

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

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