It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

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

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

0 votes
Answer accepted

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 

 

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 ...

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

Like NEGAR JALALIAN likes this

thanks a million  Pete ! it worked :)

Like Pete Singleton likes this

Try this:

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

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
Community showcase
Published in Jira

The add-in you’ve been waiting for: Jira Cloud for Excel 🙌

Introducing Jira Cloud for Excel Here at the product integrations team at Atlassian, we are thrilled to announce the new Jira Cloud for Excel add-in! This add-in lets you export Jira data directly ...

838 views 5 22
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you