Page 1 of 1

Help with reports

PostPosted: Wed Jan 23, 2013 5:18 pm
by hiadviser
Hey everyone,

I wanted to know it was possible to create a report that allows me to see a certain date of when leads were added to the system and then which ones were called or not.

So let's say yesterday I had 100 leads added to the system, is it possible to see those exact leads and which ones were called or not?


Thank you in advance for you help!

ViciDial VERSION: 2.6-385a | BUILD: 121124-1957 | Asterisk 1.4.21.2-vici | Single Server| No Digium/Sangoma Hardware | No Extra Software After Installation | Server Being hosted by someone else (dont know specs for it)

Re: Help with reports

PostPosted: Wed Jan 23, 2013 10:40 pm
by williamconley
easiest if you create a new list every day. then you would just "look" at the list and it would show you dialed/status charts.

phpmyadmin could be used to extract the data you seek:

select count(lead_id) as count from vicidial_list where entry_date > '2012-01-08 00:00:00' and entry_date < '2012-01-08 23:59:59' and called_since_last_reset='Y';
select count(lead_id) as count from vicidial_list where entry_date > '2012-01-08 00:00:00' and entry_date < '2012-01-08 23:59:59' and called_since_last_reset='N';

Of course there may be some reports that can get you this data as well, but I don't recall a report that will pull leads from all lists based on entry date.