JQL to fetching issues that have been in a specific status for longer than 3 days.
Platform Notice: Cloud - This article applies to Atlassian products on the cloud platform.
Summary
Write a query to fetch issues that have been in "In Progress" status for longer than 3 days.
Environment
Jira Cloud
JQL
Solution
The following query will fetch issues that have been in "In Progress" status for longer than 3 days.
project = "PROJECT NAME" AND status = "In Progress" AND NOT status CHANGED AFTER -3d