- 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./li>
- Available STATE values:
- running
- pause
- stop
- For example: "state: ...field name" = running - to search running stopwatch.
- "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 that 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 this conditions for the convenient search.
- For example: "time in hours TIME: ...field name" > 2 AND "time in minutes TIME: ...field name" > 45 will search for issues that time more than 2 hours and 45 minutes.
- 'For sorting, you can use any of these fields with the obligatory indication of 'ASC or DESC
- ... ORDER BY "minutes TimeSpent: ...field name" ASC