JQL

JQL

JQL extensions allow you to search for items depending on whether or not they currently have a timer running, or depending on their accumulated hours.

 

Find Items by User and Timeframe

You can use the worklogAuthor and worklogDate fields with JQL date/time functions to return issues that have been worked on during a time period.

  • This query returns a list of all items that have work reported for the current week.

     

  • Use this query to see items that the current user worked on this week.

JQL Date/Time Functions

 

 

Find Items with a Running Timer and Items with Relative Accumulated Hours are only available in Clockwork Pro.

Find Issues with a Running Timer

Use the timerIsRunning extension to find items that currently have a running timer. The example below will return all items in the HC project that have at least one timer running.

Find Issues with Relative Accumulated Hours

The allTimersInHours extension returns a numeric value that can be used in relative expressions. The example below will return all items in the HC project that more than 10 accumulated hours.