I'm trying to create some JQL to specify epics that are not changing status in 2, 3, 4, 5, 6, 7, 8, 9 and +10 weeks.
For that, I made a JQL like this:
project = "PROJECT NAME HERE" AND status in ("status 1", "status 2") AND NOT Status Changed AFTER -2w
This is getting me the issues that are not changing status in 2 weeks, but also issues with more than 2 weeks. How do I exclude issues that are no changing for more than 2 weeks from this jql?
I need to create one jql for each week, to do automations, and I can't find out how.
Such queries can be tricky to get correct as you will need to determine your date range clauses. Some things to help are:
Please look here for more information about advanced searches:
Thanks for reaching out.
Before you answered, I actually did some more experiments and got it.
The changes I made from the previous one are in bold:
project = "XXX" AND status in ("XXX", "XXX") AND NOT Status Changed AFTER -14d AND Status Changed AFTER -28d
After that, I just had to change the days for the following weeks.
Thanks anyway! :)
Hello Community members! We’re wrapping up the end of JSM June with an Ask Me Anything (AMA) with the Jira Service Management product team. This is your chance to ask all your ITSM questions to o...
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