Looking for filter to extract list of issues that are lying in open status for more than 1 year

[Anurag Verma]

Hey there, Please Help!

I am trying to extract a list of issues/bugs that are lying in open status for more than a year. I have tried multiple advanced JQLs but couldn't seem to get it.

Example - 

project in (Project1, Project2, Project3) AND issuetype = Bug AND status in (Status1, Status2, Status 3) AND NOT status CHANGED AFTER -365d

When I use the above JQL, I still get issues created in the year 2023, which should not happen. Since my ask is to get list of issues that have remained in the same status for more than 1 year, the issues should not be created after Oct 2022.

[Vishal · Accepted solution]

Hi @Anurag Verma 

With out of the box jql you wont be able to get the desired result, as there is no way to capture time in status at this moment, you may have to go for some market place app to get the perfect output. 

Or as a interim solution, you may use query as below which will give you best possible output. 

project in (Project1, Project2, Project3) AND issuetype = Bug AND status in (Status1, Status2, Status 3) AND updated <= -365d

Hope it helps you get the data you are looking for.

[Anurag Verma]

Thank you Vishal, the query worked! Will JIRA consider putting comments in issues as an update as well ?

[Vishal]

Hi @Anurag Verma 

Ideally, its a change in issue, so it should consider comment as an update but it may vary based on the type of hosting & so on. To be 100% sure, just create a test ticket & comment on it after 5-10 mins & see if the updated time stamp change or not.