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'.
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?
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.
Thanks. This is intended to get a report for how many changes were coming on the date of prod.
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"
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}}{{/}}
So, can you hardcode the date in the query? Or is it dynamic?
It looks like you're new here. Sign in or register to get started.
