How to filter for issues with specific time in status

Ron Becker August 14, 2020

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.

 

2 answers

2 accepted

5 votes
Answer accepted
Bill Sheboy
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
August 14, 2020

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

0 votes
Answer accepted
Tuncay Senturk
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
August 14, 2020

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

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
SERVER
VERSION
7.13.12
TAGS
AUG Leaders

Atlassian Community Events