nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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?

Accepted answers

Bill Sheboy

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

All comments

Bill Sheboy

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.

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira

cloud

jira-software

jira-software-cloud