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; } } }

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

Anurag Verma_4n3li4

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.

Accepted answers

Vishal_p33pdz

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.

All comments

Vishal_p33pdz

Hi @Anurag Verma

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_4n3li4

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

Vishal_p33pdz

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.

Welcome!

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

Quick Links

Find more posts tagged with

jira

unknown-hosting-type