Query for finding issues that were resolved in less that 7 days from the created date

Question

Hi-  I need a filter to show the issues that were resolved in less than 7 days from the created date. Is it possible? EG: Created: 08/01/2018 Resolved 08/05/2018 should be shown in the filter.

Piotr Bojko · Answer

Following query

SELECT * FROM issues 
WHERE resolved < CREATED + INTERVAL '7' DAY

from Smart QL https://marketplace.atlassian.com/apps/1218767/smart-ql?hosting=server&tab=overview should help.

Mohamed Adel · Answer

Hi @Gonzalo Panelo

You can solve this with script runner plugin by using the following query :

issueFunction in dateCompare("", "resolutionDate < created+7d")

I hope this will help