How to filter for issues with specific time in status

[Ron Becker]

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 solution]

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 · Accepted solution]

Hi @Ron Becker 

Have you checked JEP Time in Status documentation here?

You can use the custom field in your JQL searches.

"Time in Review" >= 4d

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

"Time in In progress" >= timeSpentInStatus("6h", "In Progress")

Hope it helps,

If you have further questions please let me know or just raise a ticket here.

Cheers

Tuncay