How can I create a JQL search to check all issues that have changed their start date?

David McMahon_0e0263

I am trying to create a filter in JQL to track down every issue where the custom field "Start Date" has been changed after it was moved into the "Review" stage of the workflow.

 

I am having trouble working out what to apply after

AND "Start date"

That checks for any changes in the "Start date" field.

Stephen.Lugton

@David McMahon with standard JQL this is not possible, unless nothing else has changed since Start Date was updated, in which case you could use 'updated' to search against, but this can't be relied on.

This is because JQL looks at the current state of any field and not previous states or when a field changed state, although there are a couple of exception for the following fields:

• Assignee
• Fix Version
• Priority
• Reporter
• Resolution
• Status

For these fields only you can use Was, Was In, Was Not In, Was Not and Changed e.g.:

• status WAS NOT "In Progress" BEFORE "2011/02/02"
• status CHANGED FROM "In Progress" TO "Open"

Even using automations with Smart Values won't let you get past this limitation.

 

---

However, there may be apps that track when fields change, but if one exists it will only work for changes made after it was installed.