Timer - JQL

Configure JQL Queries.

You can display new fields in the JQL navigator and dashboards.

  • "DATE:FIELD_NAME" = startOfDay()
      Available DATE values:
    • "started:FIELD_NAME" > startOfDay()
    • "paused:FIELD_NAME" > startOfDay()
    • "stopped:FIELD_NAME" > startOfDay()
    • "failed:FIELD_NAME" > startOfDay()
    For example: "started:FIELD_NAME" = startOfDay() - to search by start date.
  • "state:FIELD_NAME" = STATE - to search by state of timers.
      Available STATE values:
    • "state:FIELD_NAME" = running
    • "state:FIELD_NAME" = pause
    • "state:FIELD_NAME" = completed
    • "state:FIELD_NAME" = failed
    For example: "state:FIELD_NAME" = running - to search running timers.
    • "hours TIME:FIELD_NAME" > 2 - to search by time in hours.
    • "minutes TIME:FIELD_NAME" > 45 - to search by time in minutes.
      Available TIME values:
    • "hours TimeSpent:FIELD_NAME" > 2 and "minutes TimeSpent:FIELD_NAME" > 45
    • "hours PauseTime:FIELD_NAME" > 2 and "minutes PauseTime:FIELD_NAME" > 45
    • "hours LeftTime:FIELD_NAME" > 2 and "minutes LeftTime:FIELD_NAME" > 45
    Combined this conditions:
    "hours TIME:FIELD_NAME" > 2 AND "minutes TIME:FIELD_NAME" > 45 will search for issues that time more than 2 hours and 45 minutes.
  • "time in hours TIME:FIELD_NAME" > 1.5 - to search by time in hours. You can enter a fractional number. The all time will be converted to hours in decimal notation.
      Available TIME values:
    • "time in hours TimeSpent:FIELD_NAME" > 1.5
    • "time in hours PauseTime:FIELD_NAME" > 1.5
    • "time in hours LeftTime:FIELD_NAME" > 1.5
    For example: "time in hours TimeSpent:FIELD_NAME" > 1.5 - find timers that have counted down more than an hour and a half.
  • "time in minutes TIME:FIELD_NAME" > 1.5 - to search by time in minutes. The all time will be converted to minutes.
      Available TIME values:
    • "time in minutes TimeSpent:FIELD_NAME" > 90
    • "time in minutes PauseTime:FIELD_NAME" > 90
    • "time in minutes LeftTime:FIELD_NAME" > 90
    For example: "time in minutes LeftTime:FIELD_NAME" > 90 - find timers that have more than 90 minutes left until the end.
  • 'For sorting, you can use any of these fields with the obligatory indication of 'ASC or DESC
    • ... ORDER BY "minutes TimeSpent:FIELD_NAME" ASC

Timer - field configuration
Web panel
JiBrok message field Message field
JiBrok time in status Time in status | SLA | Timer | Stopwatch
Tutorials
Settings
Work calendars
Time in status
Timers and Stopwatches
Stopwatch
Timer
Additional functions
Issue panels
Reports
Field Helpers
Other fields
API
Reference information
JiBrok Switch to User + Delegating SU (Jira) Switch to User + Delegating SU (Jira)
JiBrok time in status Time in status for Jira Cloud
Work calendars
Time in status fields
Issue panels
Reports
Service tools
Reference information
JiBrok Calculated fields Calculated fields (JBCF)
JiBrok Calculated fields Calculated fields (JBCF) for Jira Cloud
JBCF fields
Service tools
JiBrok Timer Timer field | SLA for Jira Cloud
Work calendars
Timer fields
Issue panels
Service tools
JiBrok Stopwatch Stopwatch for Jira Cloud
Work calendars
Stopwatch fields
Issue panels
Service tools
JiBrok Time between dates Time between dates for Jira Cloud
Time between dates fields
JiBrok Fields panel for Jira Service Management (JSM) Fields panel for Jira Service Management (JSM)