Jql Statement to find issues that have not been worked on

Question

I am trying to find a JQL statement to find all issues that are in an open status for 7 days. I have tried

project = 'x' AND status = Open AND Department = 'x' AND NOT status changed AFTER "-7d". But it shows me a issue that I created 4/5/16 at 16:10. I even changed the -7 to a positive, changed to w and adjusted the 7 to other numbers but keeps showing the same issue. Any assistance would be helpfully.

mlassau_atlassian · Answer

You can make this work as long as you are happy to list all the statuses you want to know about it possibly being in. eg:

project = 'x' AND status = Open AND Department = 'x' AND NOT status was in (Approved, Denied) after -7d

But I think you are pushing JQL pretty hard, so this might run pretty slow especially if you have lots of data ...

David Lockhart · Answer

I was trying to not go that route since if somebody types something in the issue then it registers that it was updated. I wanted to have the time frame jql to go off the status. This way that if somebody accidentally updates the wrong ticket it does not get missed.

Doug Swartz · Answer

If you change your query to look for open issues that haven't been updated in the last 7 days, does that give you what you want?

project = 'x' AND status = Open AND Department = 'x' and updated < -7d