Advanced JQL: "Show me issues where the Deploy Date has changed in the last two weeks"

[Ernesto Ramos]

We have a field called Deploy Date and I'm wondering if anyone knows how to search for issues that have had the Deploy Date field changed within the last two weeks. Essentially, we're trying to automate tracking which deployments have had their deployment date changed. Thanks!

[Trudy Claspill · Accepted solution]

Hello @Ernesto Ramos 

Welcome to the community.

Jira has very little native functionality for searching for issue based on changes. You can find the WAS and CHANGED operators described here, but those can be applied only to a few fields.

https://support.atlassian.com/jira-software-cloud/docs/advanced-search-reference-jql-operators/

There are third party apps in the Marketplace that enhance and extend search capabilities. I have not needed one for a search like this, so I don't have an specific recommendations.

If you don't want to invest in a third party app, then you could potentially create another custom field that you update with the current date each time the Deploy Date field is changed, and then executed a search on that field. You could use Automation to populate the Deploy Date Changed field.

But, if you think you have additional needs for extending Jira JQL features or doing these kinds of searches for changes on other fields, then investing in a third party app is probably the better way to go.

[Ernesto Ramos]

Hi @Trudy Claspill,

Thank you so much for such a detailed and wonderful answer. We're looking into third-party solutions to automate our reporting :)

Best,

Ernie