Hello!
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:
Best regards,
Bill
Hey!
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! :)
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.