Issues not updated in a certain timeframe

[Thomas Cucolo]

Been researching how to find issues when they are updated at a certain point and I think i got it, But before I walk away. I am looking for the reverse.

As a Scrum master I need to find all stories of a certain size that have started to age and need updating or closing.

Here is what I came up with.

Project = ABC AND issuetype = Story AND "Story Points" = 5 AND in Sprint in openSprints() AND updated > -6d

if I understand this correctly the query will find all stories in project ABC that 5 points in size in the open sprint and has not been updated in more than 6 days.

The meaning of updated to me as I understand it is a Status change from Open to In Progress , as an example. Did I interpret the query correctly?

[Bill Sheboy · Accepted solution]

Hi @Thomas Cucolo 

Checking the field updated, you are checking for any changes, not just status.  If you want to limit the search to specific status changes, please try:

project = myProject AND issuetype = Story AND "Story Points" = 5 AND sprint IN openSprints() AND status CHANGED FROM "Open" TO "In Progress" BEFORE -6d

Please note this works well if you only have Classic projects.  If you have any Next-Gen projects, the status change functions produce unreliable results.  Here is the defect for that issue:

https://jira.atlassian.com/browse/JRACLOUD-70797

And here is some documentation on the advanced JQL functions:

https://support.atlassian.com/jira-software-cloud/docs/advanced-search-reference-jql-functions/

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

Best regards,

Bill

[Emre Toptancı _OBSS_]

By the way @Thomas Cucolo ,

updated > -6d

means the update date is in the last 6 days, so that returns the issues that WERE updated in the last six days.

If you want the issues that WERE NOT updated in the last six days, the JQL clause should be

updated < -6d

The same applies for the status change query that @Bill Sheboy gave. If you are looking for the ones that were updated more than six days ago, you should be using

BEFORE -6d

[Bill Sheboy]

Thanks, @Emre Toptancı _OBSS_   for correcting my error.

[Thomas Cucolo]

Thank you very much for the clarification I knew something was off I appreciate both @Bill Sheboy and @Emre Toptancı _OBSS_ for the assistance.