Page 1 of 1

basic report

PostPosted: Thu Aug 24, 2017 1:29 am
by ambiorixg12
Basically I want a report to see all info regarding incoming calls and outbound , I need information like agent, campaing, time date and other other fields, is there a table holding such information or it is spread between multiples tables. I was trying to check the vicidial db structure on the following site but it ha db connection issue Image

Re: basic report

PostPosted: Mon Sep 04, 2017 10:50 pm
by williamconley
Site's back online. Sorry it was down. We were moving a bunch of webs to a new server and this one got left behind somewhere.

Next up: You should really be looking at the existing reports and using the sql queries in them to build any new report(s) you need. The structure on viciwiki is far from complete. Not a paid project, as it were.

Many reports can be run with "&DB=1" to get more queries without having to actually check the code, but many of them still don't provide output for the "real" queries from this as they have not yet been retrofitted.