How do I search\filter for aged tickets

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

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

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.