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 - 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 - Search by time in minutes. Hours will be converted to minutes.
• Combined conditions:
  • "hours of:FIELD_NAME" > 1 - Search by hours. The number of hours spent in this status.
  • "minutes of:FIELD_NAME" > 30 - Search by minutes. The number of minutes spent in this status. You can combine these conditions for convenient searching.
  • 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 required indication of ASC or DESC
• ... ORDER BY "time in hours:FIELD_NAME" ASC

---

Related Docs

• Dashboard gadget - Calculated functions for time in status (Beta)
• JQL Reports and export
• Feature Difference (Server/Data Center and Cloud)
• Gadget news (Beta)
• Getting Started with Time in Status for Jira Cloud