We need to find resolved and closed tickets within 21 days in JQL

[Venkata Sagar Ganesh Rao Mahendrakar]

Hi,

Need Help in JQL

Can we find the Resolved and Closed Tickets  within in 21 days created.

Thanks

Sagar

[Trudy Claspill]

Hello @Venkata Sagar Ganesh Rao Mahendrakar 

Jira does not natively allow you to compare two date fields directly in a JQL statement. You might be able to do that with a third party app that extends JQL functionality. Are you open to acquiring such an app?

How often do you need to get this report?

Will the time period always be 21 days?

What do you want to do with the information when you have it? Do you need to distribute the list of issues to people? Do you need to show the data on a dashboard in Jira?

Are you using Jira Server or Jira Data Center? Do you have the Automation for Jira app available in your system? If so, you might be able to construct a work around where you use Automation for Jira to accomplish this.

[Venkata Sagar Ganesh Rao Mahendrakar]

Hello @Trudy Claspill .

Thanks for the Reply!!

We are using Jira Data Center. 

Regards
Sagar

[Venkata Sagar Ganesh Rao Mahendrakar]

But we are not using Automation for Jira app. 

Thanks for the Suggestion.

[Trudy Claspill]

What version of Jira Data Center are you using?

With version 9.x, Automation for Jira is automatically included.

For earlier versions it is a free app you can add.

https://marketplace.atlassian.com/apps/1215460/automation-for-jira?hosting=datacenter&tab=overview

I'm not positive that a solution could be created using the Automation feature for Jira DC. I can readily think of a solution that would work in Jira Cloud, but Automation for Jira DC does not have the same functions as Automation for Jira Cloud.

Would the time period always be 21 days?

Are you open to acquiring a non-free app to address this need?

[Trudy Claspill]

Hello @Venkata Sagar Ganesh Rao Mahendrakar 

Were you able to find a solution to your need?

[iryna_k_SaaSJet_]

Hi @Venkata Sagar Ganesh Rao Mahendrakar 

Try to use this query status changed to (Done, Closed) after -21d

[Venkata Sagar Ganesh Rao Mahendrakar]

Hi @iryna_k_SaaSJet_ ,

Thanks for the Reply!!

We wanted to know the tickets which are resolved within the 21 days after the creation. 

Could you please help on that.

Thanks 

Sagar