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 ...
I have multiple projects that use variations of the same base workflow. The variations depend on the requirements of the project or issue type. The variations mostly come in the form of new statuses ...
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
You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs