For the department, select None for Email Handling. The email template "Ticket Bounce" is sent when a ticket cannot be opened, but this assumes the response would be processed by Blesta at all. So, I'd probably suggest a no-reply@ address, and make that clear in your email templates that tickets must be updated via the UI.
Hi,
Currently i'm working with Holistics.io, where I connect it to Blesta DB via remote mysql and it shows me a full B.I dashboard with awesome statistics and charts. I would like to know if Blesta model does support a query to be able to retrieve how many services where active at a certain date.
We can't rely on Canceled or Suspended dates of 'services' table as the former can occur much later after the service was suspended, and the latter disappears when a service is unsuspended.
I'm thinking about writing a small script that logs this value every day to a database in order to be able to have this value from now on, but I would like to know if I have been missing a table that might have this information (directly or via an specific query).
Thanks!
Rodrigo
Unfortunately there is not a log of all service status changes, so producing your own log as you suggested would be the way to go. It would be good to maintain this history within Blesta, so a feature request would be welcome.