Control what your users can access and save time, money, and frustrations. Lock down sensitive data in SugarCRM or SuiteCRM to specific groups or teams. Supports unlimited assigned users, unlimited group assignments to records, custom layouts for each group, login/sudo capabilities and much more.
#2798 - Bug found on "pipeline by sales stage" and "outcome by month" dashlets
Hi Jason,
Found a bug by doing some digging on those dashlets. They were not returning any data and noticed the sg where clause generated had **secr.module = ''**
I found out the source of the problem in both modules/Charts/Dashlets/OutcomeByMonthDashlet/OutcomeByMonthDashlet.php & modules/Charts/Dashlets/PipelineBySalesStageDashlet/PipelineBySalesStageDashlet.php. I changed the call
$group_where = SecurityGroup::getGroupWhere($report_bean->table_name,$report_bean->report_bean,$current_user->id);
to
$group_where = SecurityGroup::getGroupWhere($report_bean->table_name,$report_bean->**module_name**,$current_user->id);
to fix the issue. Could exist in other dashlets, but those are the only ones I use.
-
"It works perfectly :) I had some problems when i started using it, but with some help from the team of Sugar Outfitters, everything is fine and workin..." - joaninhafonseca
Read More Reviews
9 years ago
Wow. That's embarrassing. Nice catch. I'll get this fixed for the next release.
9 years ago
LOL
Thanks
9 years ago
Fixed in upcoming 2.9.5 release. Announcement will go out when it is ready.
9 years ago
works, thanks!