Page 1 of 1

Report MYSQL Help

PostPosted: Mon Oct 14, 2013 9:54 pm
by hiadviser
I am trying to create some custom reports for an outside client. I want to print out every record that was inbound from today's date.
I've tried from the vicidial_did_log table, but I keep getting a lot of duplicates. I first select the phone_number from the vicidial_log_table, then perform a lookup in the vicidial_lists table to find the rest of the customer information. But like I said, I'm getting a lot of duplicates. Not sure if there is another table I should be looking in or what. Has anyone done this before?

Any help is greatly appreciated. Thank you.

Re: Report MYSQL Help

PostPosted: Mon Oct 14, 2013 10:02 pm
by retloc
maybe try vicidial_closer_log if you have your inbound calls transferring to a ingroup.

I typically build my inbound reports with the following tables

vicidial_closer_log = queue information
vicidial_agent_log = agent time per lead worked
vicidial_lists = if I need to pull any saved lead detail

Re: Report MYSQL Help

PostPosted: Tue Oct 15, 2013 2:14 pm
by hiadviser
Ah, lifesave. vicidial_closer_log was what I needed. Thank you.