Can I use a History search to find issues where the due date has been changed more than 2 days?

Question

I want to create an automation to alert me on a daily basis when the due dates on any issues in my project have been changed by more than 2 days.

I was hoping that I could use a History search.

If I can create a filter then I willl be able to create the automation.

I havn't had any success playing around with the History search - has anyone tried this?

Jamie Echlin _ScriptRunner - The Adaptavist Group_ · Answer

Responding specifically to your question about the JQL AI which gave you poor guidance...

This is the well-known problem of LLM hallucination. There is a version of this which runs as a DC plugin, and is able to validate and refine the query, but this is not widely available.

To attempt to answer your question. I don't think JQL is the right solution here. A better approach would be a post-function that sends a notification, or sets a custom field, if in that transition the due date had changed by 2 days or more.

stephan.lewis · Answer

Hi Petru,

You just gave me an idea - In place of Excel I already have Smartsheet linked up with Jira. I could use my bi-directional Jira connecotr to keep my Smartsheet insync with Jira. Then I could add an extra column with a formula to keep track of changes.

Will have to go play,

Thank you,

Stephan

Petru Simion [Simitech Ltd.] · Answer

Hi @stephan_lewis ,

* You could add an automation rule that uses a custom field to show the difference.

This solution has a limitation. It is going to work only from the time is implemented, leaving the rest of the issues without a value.

* You could create a scripted field which  uses the REST api to make a call and find in the issue history changes for the field you are looking for, and extract the occurences where the value is greater than two days. Then you create a scheduled job to run on a daily basis and report the issues for which the scripted field has a certain value.

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

You filter for Updted Field - Due Date.

You export your data as csv, import in Excel and use an Excel formula to depict only those rows where the difference between Value From and Value To is greater than or equal to two days.

You can run a report daily and get your data.

Regards,

Petru