by eggsurplus

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.

Cancel at any time!
Free Trial

#1486 - Reporting by Security Group

Closed General Question created by amakar 4 years ago

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?

  1. eggsurplus member avatar

    eggsurplus Provider Affiliate

    4 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.

  2. amakar member avatar

    amakar

    4 years ago

    Cheers I will give this a try!

    • amakar member avatar

      amakar

      4 years ago

      Thanks eggsurplus, I found the link.

    • eggsurplus member avatar

      eggsurplus Provider Affiliate

      4 years ago

      Awesome! Great to hear it. Let me know if you need anything else.

This case is public. Please leave out any sensitive information such as URLs, passwords, etc.
Saving Comment Saving Comment...
Rating
Rating
  • "This impressive add on is easy to use, extremely flexible, and huge time saver. This add on exceeded our expectations and is worth every penny!"

    Read More Reviews

Keep up to date on the latest additions

We'll send you an email every month with handpicked add-ons, reviews, tricks and tips. Don't worry, we hate spam as much as you do.