JQL - Is it possible to find tasks that were closed within a week since their creation?

[Daniel Orlov]

I am new to JQL and experimenting with the functionality.

I would like to find all issuetype = Task that were closed within a certain time after their creation. Is it possible? I only encountered the ways to pinpoint tasks within an absolute time frame, but not relative.

[Ollie Guan · Accepted solution]

Hi @Daniel Orlov ,

It seems that you need some plugins to assist with this query.

https://community.atlassian.com/t5/Jira-questions/JIRA-Show-tickets-Resolved-x-days-after-Created/qaq-p/1340250

https://community.atlassian.com/t5/Jira-questions/Query-for-finding-issues-that-were-resolved-in-less-that-7-days/qaq-p/873502

[Daniel Orlov]

Thanks a lot!

[Bill Sheboy]

Hi @Daniel Orlov  -- Welcome to the Atlassian Community!

If you will regularly need this data and do not want to purchase a scripting add-on, you can implement this yourself using the automation rules with JIRA cloud.  For example:

• Add a custom field to capture LeadTime (open duration)
• Add an automation rule:
  • Trigger: issue was resolved (or moved to "done")
  • Action: edit the custom field to calculate and save the difference between create and resolved time in hours

{{#=}}ROUND({{issue.Created.diff(issue.Resolved).millis}} / (1000*60*60*24), 3){{/}}

• Run a report for what you want to know about the custom field, such as: project = myProject AND LeadTime < someNumber

For more information about the automation rules, please see this documentation:

https://support.atlassian.com/jira-software-cloud/docs/automate-your-jira-cloud-processes-and-workflows/

Best regards,

Bill