Retrieving Issues who's Due date have changed

Question

Good day,

Seeking assistance from some knowledgeable individuals and seeing if it’s even possible using JQL with ScriptRunner to see when issues Expected Completion Date (A Custom Field which stands for the Due Date in my project) has changed more or less than 7 days from the Expected Completion Date that the issue originally had showing.

Example:

Expected Completion Date: April 14, 2024

User updates the Expected Completion Date

New Expected Completion Date: March 31, 2024

Thank you in advance,

Ramon

Ste Wright · Answer

Hi @C-Ramon.Alicea

You could possibly use Automation for this, with two additional custom fields?

It does depend on the parameters - my example below assumes the original date is the only important one. But you could do something like...

* Create two custom fields - Original Expected Completion Date (Date Picker), and Date Moved >7 Days (Checkboxes, with one option - Yes)
* Use Automation to...* Populate the "Original" field when the Expectation Completion Date is entered for the first time
* Check each time the Expected Completion Date is modified, and check Date Moved if it's more than 7 days

You could then use the Date Moved field in your JQL.

---

You might not even need "Date Moved" with Scriptrunner JQL functions - you might be able to use dateCompare with 2 date fields instead.

Ste

Ram Kumar Aravindakshan _Adaptavist_ · Answer

Hi @C-Ramon.Alicea

Unfortunately, you won't be able to do this via JQL. To compare the differences within the same field, the change history must be accessible.

JQL can only get the value changes for System Fields, i.e. Assignee, Fix Version, Priority, Reporter, Resolution, and Status. It's not doable for custom fields.

Please refer to this Atlassian Article for more information.

As mentioned in my previous comment, I suggest looking into the Change History using the ScriptRunner console.

I hope this helps to answer your question. :-)

Thank you and Kind regards,

Ram

C-Ramon.Alicea · Answer

Good day Rama,

With the company I support and their strict implementation of JIRA, the only method I have to attempt this ask is using JQL with ScriptRunner.