Report Question: Agent Performance Detail

All installation and configuration problems and questions

Moderators: gerski, enjay, williamconley, Op3r, Staydog, gardo, mflorell, MJCoate, mcargile, Kumba, Michael_N

Report Question: Agent Performance Detail

Postby IanGP » Mon Mar 26, 2018 9:01 am

Hi There,
Our cosultants bounce bewteen campaign depending on how many leads are available at any given time.
Therefore, when we run the Agent Performance Detail report, we select All Campaigns, All Groups, then select the individual agent.
But we get back the report listing all Live users.

Yes, only the user we selected has data displayed, but we'd rather just see the single line with the single user.
Am I missing a setting on Reports?

VERSION: 2.14-659a
BUILD: 180217-0934

Thanks
IanGP
IanGP
 
Posts: 57
Joined: Thu Jul 28, 2016 1:27 am

Re: Report Question: Agent Performance Detail

Postby blackbird2306 » Tue Mar 27, 2018 6:33 am

I have just tested it and for me it seems to be a "bug". It shows all lines for all agents (with no data for not selected ones but the line is there), though you select e.g. only one agent. This is not logical and I don't think it is intended. I found the place in code which needs to be altered in "AST_agent_performance_detail.php" file (newest revision 2951 from 2018-03-24):
at line 768 change from:
Code: Select all
$user_stmt="SELECT distinct full_name,vicidial_users.user,vicidial_users.user_group from vicidial_users,".$agent_log_table." where event_time <= '$query_date_END' and event_time >= '$query_date_BEGIN' and vicidial_users.user=".$agent_log_table.".user $live_user_SQLvu $group_SQL $user_group_SQL order by full_name asc";

to (add missing $user_agent_log_SQL in sql query):
Code: Select all
$user_stmt="SELECT distinct full_name,vicidial_users.user,vicidial_users.user_group from vicidial_users,".$agent_log_table." where event_time <= '$query_date_END' and event_time >= '$query_date_BEGIN' and vicidial_users.user=".$agent_log_table.".user $live_user_SQLvu $group_SQL $user_group_SQL $user_agent_log_SQL order by full_name asc";
Vicibox 6.0.2 from Vicibox_v.6.0.x86_64-6.0.2.iso | Vicidial 2.12-560a build: 160617-1427 | Asterisk 1.8.32.3
blackbird2306
 
Posts: 409
Joined: Mon Jun 23, 2014 5:31 pm

Re: Report Question: Agent Performance Detail

Postby mflorell » Fri Mar 30, 2018 5:05 pm

This has been fixed in svn/trunk, as well as another issue we found while we were in there.

Thanks!
mflorell
Site Admin
 
Posts: 18335
Joined: Wed Jun 07, 2006 2:45 pm
Location: Florida


Return to Support

Who is online

Users browsing this forum: No registered users and 72 guests