search for all issues that have been in their current status for more than 30 days

Kelly October 14, 2013

I'm looking to build a filter that will show all issues that have been in their current status for more than 30 days. Last updated doesn't really work since we use greenhopper and structure and Ranks are constantly getting updated which trigger the updated date. Is there any way to query this out?

1 answer

1 accepted

2 votes
Answer accepted
Jobin Kuruvilla [Adaptavist]
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
October 14, 2013

Not sure if there is an easier approach but this will work.

1. Create a filter to find issue where status was changed in the last 30 days or after the star of month, whatever you want.

status changed after -30d

2. Search for issues which are not in the filter

filter != "filter created in Step1"

Kelly October 14, 2013

Yup, this worked. Thanks!

Damian Kiesling June 27, 2016

@Jobin Kuruvilla [Go2Group], is there a way to do this same type of thing to find when a label has been added to an issue more than x days ago?

Jobin Kuruvilla [Adaptavist]
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
June 27, 2016

Unfortunately, no. History search is available only for certain standard fields.

host MAX February 16, 2017

Could directly use NOT (status changed after -30d) without creating the proxy filter

Like Terri Paik likes this

Suggest an answer

Log in or Sign up to answer