You're on your way to the next level! Join the Kudos program to earn points and save your progress.
Level 1: Seed
25 / 150 points
1 badge earned
Challenges come and go, but your rewards stay with you. Do more to earn more!
What goes around comes around! Share the love by gifting kudos to your peers.
Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!
Join now to unlock these features and more
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.
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.
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.
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.