What filter can I use to find issues that are resolved within 7 days of it's creation?

[Renee He]

For example, I am looking at tickets in a week using created >= 2018-11-25 AND created <= "2018-12-01 23:59" , and at the same time I want to see how many of those were resolved within 7 days; meaning a ticket created on 11/25 should have a resolution date >= 2018-12-02 and ticket created on 2018-12-01 will have until 2018-12-08.

But if I use (created >= 2018-11-25 AND created <= "2018-12-01 23:59") and (resolutiondate >= 2018-11-25 AND resolutiondate <= "2018-12-08 23:59") that will cause tickets that are created on 2018-11-25 and resolved on 2018-12-07 to show up as well.

[Vasiliy Zverev]

Dear Renee, hi!

You could create a filter for created issues and then use it like created >= 2018-11-25 AND created <= "2018-12-01 23:59" and filter = resolved for week

Best regards.

[Renee He]

Hi Vasiliy, could you please elaborate a bit?

Thanks!

[Vasiliy Zverev]

Here you are.

First of all you need to create a filter "Created for week" and save it with this name.

JQL is  created >= 2018-11-25 AND created <= "2018-12-01 23:59"

Then you use this filter into JQL:

(resolutiondate >= 2018-11-25 AND resolutiondate <= "2018-12-08 23:59") and filter = Created for week.

Filter return all isues for specified filter.

[Alexey Matveev]

Hello,

You would need an add-on for it.

For example you could use the Power Scripts add-on:

https://marketplace.atlassian.com/apps/43318/power-scripts-jira-script-automation?hosting=cloud&tab=overview

You could write a JQL query like this:

key in silJQLExpression('created < resolutionDate + "7d"', 'project = TEST and issueType = \"Bug\"')