Overview
Timer fields use schema properties for JQL searching.
The general syntax is:
"Your Field Name.PropertyAlias" operator value
Where Your Field Name is the name of your Timer custom field in Jira.
The property alias goes inside the same quotes as the field name, after a dot: "SLA Timer.SecondsValue" > 3600. Square brackets around the alias, a dot after the closing quote, and a custom field ID (cf[N], customfield_N) instead of the name do not work: Jira search answers such a query with an empty result instead of an error. JQL also cannot compare one field with another - the right side of a comparison is always a value.
Searchable properties
| Property | Type | Description |
|---|---|---|
| DisplayValue | text | Formatted time string |
| HoursValue | number | Hours component |
| MinutesValue | number | Minutes component |
| SecondsValue | number | Total elapsed time in seconds |
| TimeInHoursValue | number | Total elapsed time as decimal hours |
| TimeInMinutesValue | number | Total elapsed time in minutes |
| StateValue | text | Current state: Inactive, Running, Paused, Completed, or Failed |
| GoalTimeSeconds | number | Goal time in seconds |
| LeftTimeSeconds | number | Remaining time in seconds (goal minus elapsed) |
| PauseTimeSeconds | number | Accumulated pause time in seconds |
| DateNextUpdate | date | Next scheduled recalculation |
| FirstStartDate | date | When the timer first started |
| LastStartDate | date | When the timer last started or resumed |
| StopDate | date | When the timer was stopped/completed |
| FailDate | date | When the timer failed (exceeded goal) |
| LastPauseDate | date | When the timer was last paused |
| RestartCount | number | Number of restarts |
Query examples
Find all failed timers
"SLA Timer.StateValue" = "Failed"
Find running timers with less than 1 hour remaining
"SLA Timer.StateValue" = "Running" AND "SLA Timer.LeftTimeSeconds" < 3600
Find timers that failed this week
"SLA Timer.FailDate" >= startOfWeek()
Find completed timers with goal under 4 hours
"SLA Timer.StateValue" = "Completed" AND "SLA Timer.GoalTimeSeconds" < 14400
Find timers that have been restarted
"SLA Timer.RestartCount" > 0
Sorting
project = "SUPPORT" ORDER BY "SLA Timer.LeftTimeSeconds" ASC
project = "SUPPORT" AND "SLA Timer.StateValue" = "Failed" ORDER BY "SLA Timer.FailDate" DESC
Notes
- Replace
"SLA Timer"with your actual Timer field name. LeftTimeSecondscan be negative for failed timers (shows how much time was exceeded).- Text property searches (StateValue, DisplayValue) are case-sensitive.
- Date properties support Jira date functions:
startOfDay(),startOfWeek(),now(), etc.

