JQL to search due date history

Question

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

Rahul_RVS · Answer

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_ · Answer

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.] · Answer

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