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 ...
Hey Community mates! Claire here from the Software Product Marketing team. We all know software development changes rapidly, and it's often tough to keep up. But from our research, we've found the h...
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