Tracking changed due dates

[DENISE M WATSON]

Is there a formula to filter issues in which the due date has been changed?

[Ste Wright · Accepted solution]

Hi @DENISE M WATSON

Not in JQL - there are some history searches but only for a very small group of fields, of which due date is not one of them.

You could pull the issue history for issues via REST API and get the information from there if required - see more details on the REST API by clicking here.

If I was to do this with JQL, this is what I would do:

• Create a dashboard for due dates with multiple filtered lists - eg. due in 1 month, 2 months, 3 months
• Look for anomalies in these lists when checked (eg. each day)
• Provide a list of all issues which meet these three filters that were updated since the last check (eg. in last 24 hours)

^ It's not an ideal solution, but this would allow me to consider issues which are moving between lists and updated within a 24 hour period. This remains a real-time option, aside from just exporting a copy of the data once a day and doing a VLOOKUP or similar.

Ste

[DENISE M WATSON]

Thank you for your help.