Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

JQL query to view oldest tickets in the past 90 days?

Bell Lopez
Contributor
July 26, 2018 edited

Hello,

I was viewing an average age report I created to see how long tickets in our service desk had been open in the past 90 days and saw that we had some tickets open/unresolved for longer than 30 days. It doesn't look like you can drill down into the report and view specifically WHAT tickets were unresolved for this period.  I know this report calculates an average so I was wondering if anyone had any idea of how to write a JQL query to find the specific tickets that were unresolved for a long period of time (say 30 days) in the past 90 days?

 

Best wishes,

Bella

2 answers

1 accepted

3 votes
Answer accepted
Moses Thomas
Community Champion
July 26, 2018 edited

@Bell Lopez 

 created >= startOfDay(-90d) AND project in(A,B, .....)  AND resolution = unresolved

This  should do the trick  completely.

 

Best!

Bell Lopez
Contributor
August 2, 2018

Thank you, both! @Moses Thomas This worked!

Moses Thomas
Community Champion
August 2, 2018

@Bell LopezYou  are welcome!

Fabio Genovese
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
August 2, 2018

@Bell Lopez Thanks :)

Robert.Geritano June 7, 2023

This worked thank you

1 vote
Fabio Genovese
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
July 26, 2018

Try use this condition in JQL:

created >= startOfDay(-90d)

Fabio Genovese
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
July 26, 2018

project = <keyproject>   -- Select the project

AND created >= startOfDay(-90d) -- created 90 days ago or after

AND resolution = Unresolved -- resolution = unresolved

Like • rpatterson likes this

Suggest an answer

Log in or Sign up to answer
TAGS
atlassian, likes for trees, atlassian community, social impact, tree planting campaign, community kudos, atlassian giving, environmental impact, sustainability, likes for good, atlassian social responsibility, community challenge

Make every click count—help us plant 50,000 trees! 🌳

Want to make your everyday Community actions directly contribute to reforestation? The Atlassian Community can achieve this goal by liking a post, attending an ACE, sending your peers kudos, and so much more!

Help us plant more trees
AUG Leaders

Atlassian Community Events