Resolution

[Seda Tugay]

I have been trying to find a a way to make a JQL filter to get a list of issues which have been moved to the DONE status since its creation less than 2w . which means updated- created is less than 2w. Any help ?  Thanks

[Manoj Gangwar]

Hi @Seda Tugay ,

Welcome to the Atlassian Community!

You may try the below JQL.

Project = xyz AND status = DONE AND (updated >= -2w OR created >= -2w)

[Seda Tugay]

Hi @Manoj Gangwar 

Thank you for your prompt reply. However, the filter didn’t work as expected—I’m still seeing issues that were created in May and moved to "Done" in August.

I’d like to determine how many issues were resolved within 2 weeks of their creation.

[Manoj Gangwar]

Unfortunately, JQL doesn't support direct date arithmetic like "resolved within 2 weeks of creation" out of the box, but you can achieve this with a bit of a workaround by using Jira's custom fields or scripts if you have Jira ScriptRunner.

Here’s a basic approach if you don’t have access to advanced add-ons:

1. Find Issues Resolved in the Last 2 Weeks:

   resolved >= -2w

2. Combine with Creation Date Query: To find issues created in a specific timeframe, you need to adjust your query. For example, to find issues created in the last month and resolved in the last 2 weeks, you would use:

   created >= -4w AND resolved >= -2w

   This isn’t exactly "resolved within 2 weeks of creation" but gives you a subset of issues resolved recently.

If you need to be precise about the 2-week resolution window relative to creation, consider these advanced options:

Using ScriptRunner for Jira (if available)

1. Create a Scripted Field or Use the Enhanced Search: You might use ScriptRunner's JQL functions or create a custom field to calculate the time difference between creation and resolution.

2. Example Scripted JQL: You could use a script like this:

   issueFunction in dateCompare("created + 2w >= resolved")

[Aaron Pavez _ServiceRocket_]

Hi @Seda Tugay 

They discuss your request on this post:

https://community.atlassian.com/t5/Jira-questions/JQL-to-show-issues-where-status-changed-from-one-to-another/qaq-p/1269093

Regards