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 · Accepted solution]

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.

[Tatiana Marti]

Hi @Tuncay Senturk 

Thanks a lot for the answer.

Tania