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 for 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
  Combining these 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. 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. 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 required indication of ASC or DESC
  • ... ORDER BY "minutes TimeSpent:FIELD_NAME" ASC

---

Related Docs

• Feature Difference (Server/Data Center and Cloud)
• Getting Started with Timer Field for Jira Cloud
• Install Timer Field for Jira Cloud
• Migration from Server/Data Center
• Timer for Jira Cloud - Countdown & SLA Tracking