Error in Agent Performance Comparison Report?

[geoff3dmg]

I just updated my Vicidial 5.03 install to SVN r2101. I was trying out the new Agent Performance Comparison Report and it does not make sense to me. The 'Sales' column seems to be a far higher number than it should be for my agents. I have double checked and don't have any statuses set to Sale = Y that shouldn't be.

[geoff3dmg]

To answer my own question, I had a poke around in the PHP and looking over the snippets of SQL there appears to be an error in the SQL statement in AST_performance_comparison_report.php on line 578. I changed:

Code: Select all

$sale_stmt="select distinct status from vicidial_campaign_statuses where sale='Y' $group_SQL UNION select distinct status from vicidial_statuses order by status asc";

to:

Code: Select all

$sale_stmt="select distinct status from vicidial_campaign_statuses where sale='Y' $group_SQL UNION select distinct status from vicidial_statuses where sale='Y' order by status asc";

and now the report looks much more correct.

[geoff3dmg]

Submitted to the bug tracker as issue #752.

http://www.vicidial.org/VICIDIALmantis/view.php?id=752

[mflorell]

Should be fixed in svn/trunk now. Thanks!