how to make JQL filter for issues the status not changed over 10 days

NEGAR JALALIAN November 7, 2019

Anyone can help with this ?

I know it is possible to make a filter based on status changed from X to Y .

but what I need to make is : a filter of issues that their status was not changed for long time ... 

2 answers

1 accepted

11 votes
Answer accepted
Pete Singleton
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.
November 7, 2019

You can use "NOT Status Changed AFTER" in your JQL query.

For example:

Project = X AND NOT Status Changed AFTER -10d

This would show issues where the status has not changed in the last 10 days.  However, this would also show new issues created in this time.  To remove these:

PROJECT = X AND NOT Status Changed AFTER -10d AND Created < -10d 

 

NEGAR JALALIAN November 7, 2019

Hi Pete , this worked but it included the close issues too .. 

how about a filter that tells those issues with the status of X,Y,Z that status not changed for more than 10 days ...

Pete Singleton
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.
November 7, 2019

Just add "AND Status in (X, Y, X)".   Or alternatively "Status != Closed"

Like NEGAR JALALIAN likes this
NEGAR JALALIAN November 7, 2019

thanks a million  Pete ! it worked :)

Like Pete Singleton likes this
Andrew L February 24, 2020

Hi

How do i query for "status has NOT changed for exactly X days"?

Thanks

--Andrew

Sara Engels July 21, 2022

@Pete Singleton I don't seem to be getting accurate results when trying these queries in Jira Cloud- is that expected

0 votes
Ravi_P November 7, 2019

Try this:

status changed from X to Y before startOfDay(-10)

NEGAR JALALIAN November 7, 2019

this won't cover my requirement .. because I don't mind the target status .. all I care is those issues people missed to work on it 

Suggest an answer

Log in or Sign up to answer