Status changed date is same as 'Prod Date'

[Chakra]

Hi,

Please help me with a query. Want to find how many changes are moved to 'CAB' Status on the same day as 'Prod Date'. 

[John Funk]

Hi Chakra - Welcome to the Atlassian Community!

You are not going to be able to do that with a regular JQL query. Maybe with a ScriptRunner query or by using Automation. What is your intended purpose for using the data? 

[Chakra]

Thanks. This is intended to get a report for how many changes were coming on the date of prod. 

[John Funk]

So, can you hardcode the date in the query? Or is it dynamic? 

[Marc - Devoteam]

Hi @Chakra 

Welcome to the community.

You can use a JQL as follows:

status CHANGED TO "CAB" and "Prod Date" = "2025-08-15"

Set the date to your required date.

[Chakra]

Im looking for all the changes for the year.  

something like - status CHANGED TO "CAB" is equal to 'prod date' where 'prod date' >= "2025-01-01"

[Marc - Devoteam]

Hi @Chakra 

This is not possible with JQL.

You could create an automation and lookup issues that match jql 

status CHANGED TO "CAB" and ("Prod Date" >= startOfYear(-1) or "Prod Date" <= startOfYear())

and then sent yourself an email by using the smart values in the body

{{#lookupIssues}}
* {{key}} | {{summary}} | {{Prod Date}}
{{/}}