Time in Status (Forge) for Jira CloudOverview
Time Between Dates fields use schema properties for JQL searching.
The general syntax is:
"Your Field Name[PropertyAlias]" operator value
Searchable properties
| Property | Type | Description |
|---|---|---|
| DisplayValue | text | Formatted time string |
| HoursValue | number | Hours component |
| MinutesValue | number | Minutes component |
| SecondsValue | number | Total elapsed time in seconds |
| TimeInHoursValue | number | Total elapsed time as decimal hours |
| TimeInMinutesValue | number | Total elapsed time in minutes |
| StateValue | text | Current state: Active or Inactive |
| GoalTimeSeconds | number | Goal time in seconds (if configured) |
| LeftTimeSeconds | number | Remaining time in seconds |
| DateNextUpdate | date | Next scheduled recalculation |
Query examples
Find issues where time between dates exceeds 5 days
"Resolution Time[TimeInHoursValue]" > 120
Find issues resolved within 4 hours
"Resolution Time[TimeInHoursValue]" <= 4
Find active (still calculating) fields
"Resolution Time[StateValue]" = "Active"
Sort by resolution time
project = "MY-PROJECT" ORDER BY "Resolution Time[TimeInHoursValue]" DESC
Notes
- Replace
"Resolution Time"with your actual field name. - If the field uses
currentDateTimeas the end date, values update periodically. - Text property searches are case-sensitive.
