JQL to ignore custom field changes after a specific time

Question

I am trying to find all tickets that had a Status update to Deployment on Wed each week which have a certain Release Date window, which is tracked in a custom field.  The problem is that if a Release Date is updated after the Status change then the ticket drops out of the report.  This is what I have for my JQL.

Project = PROJECTNAME AND Status changed to Deployment during (startOfWeek(3d), startOfWeek(4d)) AND "RELEASE DATE" in (startOfWeek(3d), startOfWeek(10d))

Is there JQL that will include all tickets that were with within this Release Date timeframe regardless of current dates.

Dan -minware- · Answer

Disclaimer: 3rd party market place partner

Hey @Chris Harris this is something that we can help with at minware using minQL:

We offer a free trial if you want to check it out!

Seon Shakespeare · Answer

Hi Chris,

While JQL can track some history, it can't directly show you the value of a custom field at a specific past date.

To track the release date as it was at the time of deployment, you could try adding a new status like "Deployment Scheduled" or a custom field like "Original Release Date" that captures the release date during the "Deployment" transition.

This way, you'll have a record of the historical release date even if it's updated later.

Hope this helps!