How to filter for issues with specific time in status

Question

Hi,

I would like to know if it is possible to filter (JQL) for issues exceeding a defined number of days/months in a specific status?

"- For example: Project=XYZ AND Status=InProgress AND time-in-status>1mnd

We have the enhancer plugin (JEP fields) and the "Time in Status" add-on available in our environment but I can't find a way to achieve this. Any help is appreciated.

Bill Sheboy · Accepted Answer

Hi @Ron Becker

Have you tried CHANGED AFTER advanced JQL?  Maybe something like:

project = myProject
 AND statusCategory = "In Progress"
 AND NOT status CHANGED AFTER -30d
 ORDER BY Key

Best regards,

Bill

Tuncay Senturk _Snapbytes_ · Accepted Answer

Hi @Ron Becker Have you checked JEP Time in Status documentation here? You can use the custom field in your JQL searches. >= 4d

"Time in Waiting for support" >= timeSpentBy("5d", "agrant", "jevans", "hjennings")

"Time in In progress" >= timeSpentInStatus("6h", "In Progress")"Time in Review" Hope it helps, If you have further questions please let me know or just raise a ticket here. Cheers Tuncay