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
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
Online forums and learning are now in one easy-to-use experience.
By continuing, you accept the updated Community Terms of Use and acknowledge the Privacy Policy. Your public name, photo, and achievements may be publicly visible and available in search engines.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.