Time in Status Custom Field in JQL

You can search, filter, and sort work items by a Custom Field by Time in Status directly in JQL — in issue search, saved filters, dashboards, and automation rules.

Referencing the field

Reference a field by its name in JQL:

"TIS [Review]" > 2h

Supported operators

Duration values

Comparisons use human‑readable duration values in days and hours:

• d — days

• h — hours

"TIS [DEV Proj]" > 1d

Finds items where time in the [DEV Proj] statuses exceeds 1 day.

Only days and hours are supported.

Format

The field is displayed as days and hours (dd hh) but stored and compared in seconds. JQL comparisons and ORDER BY run against the precise second value, not the truncated display — so an item shown as 1d can still match > 1d if its exact stored time is a little over a day.

Through the Jira REST API the same field is returned as two values: renderedFields — the formatted dd hh display — and fields — the raw value in seconds.

Combining with other criteria

Combine Time in Status fields with any standard JQL:

status = "In Progress" AND "TIS [Review]" >= 2h

Before you rely on JQL

• The field must have a value written by an update run. A field that has never run (or has no schedule set) shows as empty and won't match value comparisons.

• Values refresh on the field's configured schedule (hourly, daily, or weekly) or when you run Update now — not instantly on status change. Expect values to reflect the last run.