Time in status - JQL

    Configure JQL Queries.
  • You can display new fields in the JQL navigator and dashboards.
  • "time in hours: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.
  • "time in minutes:FIELD_NAME" > 90 - to search by time in minutes. Hours will be converted to minutes.
  • Combined conditions:
    • "hours of:FIELD_NAME" > 1 - to search by hours. The number of hours spent in this status.
    • "minutes of:FIELD_NAME" > 30 - to search by minutes. The number of minutes spent in this status. You can combine this conditions for the convenient search.
    • For example: "hours:FIELD_NAME" > 2 AND "minutes:FIELD_NAME" > 45 will search for issues that spend more than 2 hours and 45 minutes in the defined status.
  • 'For sorting, you can use any of these fields with the obligatory indication of 'ASC or DESC
  • ... ORDER BY "time in hours:FIELD_NAME" ASC

Time in status - 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)
JiBrok Display Linked Issues Display Linked Issues
User helper for JiBrok cloud apps User helper for JiBrok cloud apps