JQL to search due date history

[joel.geller]

As part of a Dashboard I'm trying to create a filter to show Bugs or Epics that have had their due date changed. I know the WAS IN JQL operator will look at a history, but can it look at a history for duedate and compare the current duedate to the original?

If there is a way, is there a way to report out a list of those items showing how many times the duedate was changed (count of rows in the duedate history)?

TIA

[Yuliia_Borivets__SaaSJet_]

Hi @joel.geller 

If you are open to using apps, you can try Issue History for Jira, which my team developed.

The app provides customizable reports to see changes across any field.

Here is an example with due dates:

Gadget on Jira dashboard is also available, but in a slightly different format where due date changes are based on the date of change. 

[Walter Buggenhout]

Hi @joel.geller and welcome to the Community!

No. Unfortunately, history search is not supported for the due date:

Hope this helps!

[Rahul_RVS]

Hi @joel.geller 

Welcome to the community !!

As you rightly mentioned, you can use the "History" tab in the issue screen to tracks the changes the issue went through including the assignee changes. You can also use Jira Rest Api's to pull this information and build your own custom solution.

However if you need detailed reporting to track history changes for multiple issues, you may want to have a look at a mktplace app for the same.

We have built an app to extract changelog data in a simple and easy to use interface.

Issue History Reports

[Tuncay Senturk _Snapbytes_]

Hi @joel.geller 

Unfortuntaley, you have to use an app to achieve that.

If you are open to using a free app, you can view any issue field change by using the Issue History Report of the SnapMetrics - Real Time Analytic app, which is available on the Marketplace. You can see every change along with the date, time, and user information. I am one of the developers of the app, so feel free to ask any questions.

[Petru Simion _Simitech Ltd__]

Hi @joel.geller ,

You can not achieve this with  of the shelf Jira features.

If you are open to using apps you can use Issue History Dashboard for Jira  an app provided by our company.

You can filter by Field Updated - Due Date.

You can export your result in csv format for further analysis.

Regards, 

Petru