Forums

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

How do I search\filter for aged tickets

IT June 26, 2018

I need to be able to search for any tickets that has more than 30 days between the date created and date resolved. 

 

The dates for my search are 1/07/2017 - 30/06/2018 

1 answer

1 vote
Sana Safai
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.
June 26, 2018

If you have ScriptRunner you can run this query:

issueFunction in dateCompare("YOUR SUBQUERY HERE", "created + 30d < resolved") AND (created >= 2017-07-01 AND created <= 2018-06-30)

 

Edit: changed the function to dateCompare from expression

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events