It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Tracking changed due dates

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

1 answer

0 votes
Stephen Wright Community Leader Oct 02, 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

Thank you for your help.

Suggest an answer

Log in or Sign up to answer
Community showcase
Published in Jira

The add-in you’ve been waiting for: Jira Cloud for Excel 🙌

Introducing Jira Cloud for Excel Here at the product integrations team at Atlassian, we are thrilled to announce the new Jira Cloud for Excel add-in! This add-in lets you export Jira data directly ...

864 views 6 24
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you