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.
I am trying to write the jql to tell me which issues that have been open and never been updated or worked on. I have the project setup where people put in the issues and then an approver approves or denies the issues then it gets assigned to somebody. So I need a script that tells when a issue is still in open after 7 days and never transition to Approved or deny.
So then I can email that approver
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 ...
Connect with like-minded Atlassian users at free events near you!Find a group
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no AUG chapters near you at the moment.Start an AUG
We're bringing product updates and pro tips on teamwork to ten cities around the world.Save your spot