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

[Kelly]

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?

[Jobin Kuruvilla [Adaptavist] · Accepted solution]

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]

Yup, this worked. Thanks!

[Damian Kiesling]

@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]]

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

[host MAX]

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