vicidial.org

What situations would cause the lead_id to be NULL within vicidial_agent_log I have thousands of NULL records..

When an agent logs in or out there is no associated lead with the record, but the record must still exist for pause-time/wait-time accuracy reasons.

When running these queries Im showing different outcomes, shouldnt they be the same?

Code: Select all

SELECT *
FROM  vicidial_list,vicidial_log
where vicidial_list.lead_id=vicidial_log.lead_id
and vicidial_list.user=vicidial_log.user
and vicidial_list.status=vicidial_log.status
and vicidial_list.list_id=vicidial_log.list_id
and vicidial_list.list_id='10000001'
and (vicidial_list.status="DC" or vicidial_list.status="DEC" or vicidial_list.status="DNC" or vicidial_list.status="NI" or vicidial_list.status="SALE" or vicidial_list.status="W" or vicidial_list.status="K" or vicidial_list.status="R" or vicidial_list.status="Z");
2809 results


select *
FROM  vicidial_list
where vicidial_list.list_id='10000001'
and (vicidial_list.status="DC" or vicidial_list.status="DEC" or vicidial_list.status="DNC" or vicidial_list.status="NI" or vicidial_list.status="SALE" or vicidial_list.status="W" or vicidial_list.status="K" or vicidial_list.status="R" or vicidial_list.status="Z");
2917 results


DC (disconnects) can be dispositioned by the system without ever going to an agent and might account for some of the difference.

Also, I have been tracking a bug lately that seems to come up when an agent tries to login when they already have an active session going. It causes the status of the lead to be changed in the vicidial_list table because the lead was never changed from INCALL the last time it was called even though there is a vicidial_log entry for it. This does not seem to be a problem on every system, just some. I have been tracking it by changing the vicidial.php line that changes the status of all INCALL leads. Not sure if that's the same as your problem, but it causes the same kind of result.