Hey there, we're looking forward to write an automation which will send a mail to every employee every week, containing a list with their tickets which aren't finished yet.
We'd rather not use the subscription filter, since it's not as versatile, the user can unsubscribe and it's harder to edit the templates.
For one user this works great using a scheduled automation (with bulk processing to not create a flood of mails for every single issue) and then filtering for "statusCategory != Done". Then, the automation is set to send a mail to the assignee.
This was the most logical system we could come up with, however (obviously) it leads to problems - the mail is containing EVERY open ticket and is being sent with identical content to all assignees.
So my question is: How do we execute an automation on behalf of every single assigne in a group? This way, the automation could just be set to filter for "currentUser()" and, since it's being executed on behalf of everyone themselves, it'll only contain their content and'll only be sent to them specifically.
It'd be kinda complicated to write a new automation for every single user.