AUTOMATION. Empty assignee longer then X days

[Mateusz Janus]

Hello Brothers and Sisters
I want to build automation. Every Sunday I want to send email with list of tickets where assignee is empty longer then 7 days. And the question is, is it possible to build such JQL which detects that ASSIGNEE field is empty for X days?

[Walter Buggenhout · Accepted solution]

Hi @Mateusz Janus,

You can try the following JQL:

assignee = EMPTY AND assignee WAS EMPTY DURING (-7d, now())

You don't even need to use an automation rule to send the email (you can, but there may be an alternative approach). If you save the above as a filter, you can also set up a filter subscription to send out the weekly email: from Filter Details > Subscriptions > Add Subscriptions you can set this up.

Hope this helps!