New ticket notification for unassigned technicians only
I used the SQL template to get the new ticket notification emails here:
It's working but I would like to only get new ticket emails if the ticket is not assigned to any technician. Basically my users CANNOT assign a technician to a ticket (the field is hidden to them) and would like to get an email when they open tickets. But when a technician opens a ticket and assigns it to himself we don't want to get an email notification since he has already assigned it to himself and therefore taken ownership of it. Right now we are getting too many new ticket emails that are already taken care of. Can this be modified to make it work like this?
There are no answers at this time