Canceling tickets automatically opens on a specific or range of days.

[Marina Vital]

Hello Community,

I'm creating an automation to automatically cancel open tickets from the 25th (0:00 am) until the last day of each month, but I can't find a jql filter to search for this.

Can you help me?

[Marina Vital · Accepted solution]

Hi,

I managed to assemble the automation using the smart value {{now.DayOfMonth}}.

Thank you for your help!

[Walter Buggenhout]

Hi @Marina Vital ,

I am really curious why you would want to do something like that, but apart from that - I may have a workaround, at least if I understand you correctly.

Using cron scheduling (see this support article) you could create an automation rule that runs on the 25th, 26th, 27th, 28th, ... 31st of every month to close all open issues.

I am assuming that you want to close all open issues on those days. But if I misunderstood, you can still use the scheduled automation rule to extend your JQL filter with relative dates, e.g. something like this:

Project = ABC AND Resolution = Unresolved AND updated <= -14d

 This would select all open issues that weren't updated in the last 14 days - relative to the date on which the automation rule gets triggered. You can of course modify that to suit your specific requirements.

Hope this helps!

[Marina Vital]

Hi @Walter Buggenhout

This automation will run on a project of the Finance team. They only process payment requests between the 1st - 24th of each month. If the supplier opens a ticket on the 25th, for example, we want it to be canceled automatically, without the analyst having to make the transition.

[Marina Vital]

Hi,

I managed to assemble the automation using the smart value {{now.DayOfMonth}}.

Thank you for your help!