Tracking changed due dates

DENISE M WATSON October 1, 2019

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

1 answer

1 accepted

1 vote
Answer accepted
Stephen Wright _Elabor8_
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
October 2, 2019

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 October 3, 2019

Thank you for your help.

Suggest an answer

Log in or Sign up to answer