vicidial.org

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

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";


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

Thanks!