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.
#1486 - Reporting by Security Group
Hello, Just started using Suite and love it. I have set up the security groups, however now I'm trying to report on Leads and Opportunities by SecurityGroup and am having trouble getting this relationship I have created a relationship between a lead and a Security Management module however this is not reflecting in an SQL. I guess the question is, Can I associate and report on leads and Opportunities by Security Group?
-
"I can say that it has been one of the best modules within our SugarCRM CE instance!"
Read More Reviews
9 years ago
Hi there, I converted that comment over to a separate case.
You'll want to join on the securitygroups_records table if doing this via SQL.
9 years ago
Cheers I will give this a try!
9 years ago
Thanks eggsurplus, I found the link.
9 years ago
Awesome! Great to hear it. Let me know if you need anything else.