nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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.

Accepted answers

Ollie Guan

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

All comments

Ollie Guan

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

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

server

cloud

jira-software

jira-cloud

jira-software-server

jql