Send daily emails to ticket owner with the open tickets for that owner.
I don't know much about SQL but i've been asked to accomplish the following.
We want to generate daily emails that contains only the open tickets per owner and send only those tickets to that owner.
I can accomplish this by creating an custom ticket rule with a SQL query based on the owners id or username en set the owners email adress in the recipients list. But we want to email only that user with those tickets so we have to create a lot of rules to do this. Is there another way to accomplish this? For example using variables in the SQL query and recipients list?