Scenario is the call was transferred from a Fronter to a Closer
The call from the Fronter appears in the Agent Log while the call from the closer only appears on the closer log and no log in the agent log.
I noticed it since some sales calls are not appearing in the Agent Performance Detail report.
Please see the results of the query below for the lead that is in question
- Code: Select all
select * from vicidial_agent_log where lead_id='28080889';
# agent_log_id, user, server_ip, event_time, lead_id, campaign_id, pause_epoch, pause_sec, wait_epoch, wait_sec, talk_epoch, talk_sec, dispo_epoch, dispo_sec, status, user_group, comments, sub_status, dead_epoch, dead_sec, processed, uniqueid, pause_type
'36555599', 'FLMHinton', '10.5.100.52', '2021-01-29 10:13:12', '28080889', 'SPORTS', '1611933192', '0', '1611933192', '5', '1611933197', '109', '1611933306', '3', 'XFCELN', 'FLTransfers', NULL, NULL, '1611933306', '0', 'N', '1611933195.7346470', 'AGENT'
select * from vicidial_closer_log where lead_id='28080889';
# closecallid, lead_id, list_id, campaign_id, call_date, start_epoch, end_epoch, length_in_sec, status, phone_code, phone_number, user, comments, processed, queue_seconds, user_group, xfercallid, term_reason, uniqueid, agent_only, queue_position, called_count
'3002385', '28080889', '7133', 'LostPromoTransfer', '2021-01-29 10:15:07', '1611933307', '1611933746', '549', 'SALEN', '1', '6076938115', 'FLJMiranda', 'AUTO', 'N', '14.00', 'FLFronts', '1689301', 'CALLER', '1611933195.7346470', NULL, '2', '2'
select * from vicidial_xfer_log where lead_id='28080889';
# xfercallid, lead_id, list_id, campaign_id, call_date, phone_code, phone_number, user, closer, front_uniqueid, close_uniqueid
'1689301', '28080889', '999', 'LostPromoTransfer', '2021-01-29 10:15:07', '1', '6076938115', 'FLMHinton', 'FLJMiranda', '1611933195.7346470', '1611933195.7346470'
1) ViciBox v.8.1.2 | version 2.14-632a | SVN 3057 | DB Schema 1561
2) load average: 0.25, 0.22, 0.24
3) Asterisk 13.21.1-vici