How do I track status not changed in a period of weeks?

Question

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.

Lusca Fontoura · Answer

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! :)

Bill Sheboy · Answer

Hi @Lusca Fontoura

Such queries can be tricky to get correct as you will need to determine your date range clauses.  Some things to help are:

* Draw yourself a timeline on paper, indicating what you care about.  For example, -1w, -2w, -3w...
* Mark your use cases and ranges on the timeline
* The CHANGED operator can check on different units of measure, such as hours, and is defaulting to check NOW(-2w) when you check as in your query...so...
* Add the startOfWeek() and endOfWeek() functions to help
* Consider using DURING for ranges

Please look here for more information about advanced searches:

https://support.atlassian.com/jira-software-cloud/docs/advanced-search-reference-jql-operators/#Advancedsearchingoperatorsreference-CHANGEDCHANGED

Best regards,

Bill