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

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

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"

Yup, this worked. Thanks!

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

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

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

Suggest an answer

Log in or Join to answer
Community showcase
Sarah Schuster
Posted Jan 29, 2018 in Jira

What are common themes you've seen across successful & failed Jira Software implementations?

Hey everyone! My name is Sarah Schuster, and I'm a Customer Success Manager in Atlassian specializing in Jira Software Cloud. Over the next few weeks I will be posting discussion topics (8 total) to ...

3,323 views 14 20
Join discussion

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you
Atlassian Team Tour

Join us on the Team Tour

We're bringing product updates and pro tips on teamwork to ten cities around the world.

Save your spot