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 som search examples.

 

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 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