Stopwatch - JQL

Cloud This page documents the Connect build of Stopwatch for Jira Cloud. Looking for the current Cloud app? See Stopwatch Field (Forge) for Jira Cloud. On Jira Data Center or Server? See Stopwatch field for Data Center.
    Configure JQL queries.
  • You can display new fields in the JQL navigator and dashboards.
  • "DATE: ...field name" = startOfDay()
      Available DATE values:
    • started
    • paused
    • stopped
    • For example: "started: ...field name" = startOfDay() - to search by start date.
  • "state: ...field name" = STATE - to search by state of stopwatch.
    • Available STATE values:
    • running
    • pause
    • stop
    • For example: "state: ...field name" = running - to search for running stopwatch.
    </li>
  • "hours TIME: ...field name" > 1.5 - to search by time in hours. You can enter a fractional number. Minutes will be converted to hours in decimal notation.
  • "minutes TIME: ...field name" > 90 - to search by time in minutes. Hours will be converted to minutes.
      Available TIME values:
    • TimeSpent
    • PauseTime
    • For example: "time in hours TimeSpent: ...field name" > 2 AND "time in minutes TimeSpent: ...field name" > 45 - will search for issues with time spent more than 2 hours and 45 minutes.
  • Combined conditions:
    • "time in hours TIME: ...field name" > 1 - to search by hours. The number of hours.
    • "time in minutes TIME: ...field name" > 30 - to search by minutes. The number of minutes. You can combine these conditions for convenient searching.
    • For example: "time in hours TIME: ...field name" > 2 AND "time in minutes TIME: ...field name" > 45 will search for issues with time more than 2 hours and 45 minutes.
  • For sorting, you can use any of these fields with the required indication of ASC or DESC
    • ... ORDER BY "minutes TimeSpent: ...field name" ASC