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).
Question
Rodrigo
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
1 answer to this question
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.