JQL: write a query regarding release dates

Tatiana Marti

Hello,

We have users asking us for the possibility to search based on the end date of a release. Example: tickets with status changed to In progress 3 days before the end of the release. Knowing that they would change their release every month. So something like this

status changed To "In Progress" After ...

For the following, we should be able to put the expected version with the duration fixversion(-3). Do you know if this is possible?

Thanks a lot

Tuncay Senturk _Snapbytes_

Hi @Tatiana Marti 

Unfortunately, Jira JQL does not support dynamic date calculations natively (in your case, based on a fix version's release date) natively. You can either use a custom field which will be automatically set (with Automation) and use this date in your JQL, or use ScriptRunner's issuefunction in dateCompare function.