SecuritySuite - Enhanced SuiteCRM Teams

by eggsurplus

Control what your users can access and save time, money, and frustrations. Lock down sensitive data in 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

#3218 - Mass Assign Leads to Security Group SuiteCRM 7.11.18

Closed Bug? created by nelem 4 years ago

When mass assigning all Lead records in a ListView, the query fails because the join table has the wrong alias in the where clause. The query produced refers to the join table as relJoin1 but the $_SESSION['export_where'] uses jt0 in MassAssign.php line 44.

Happy to provide more details.

  1. eggsurplus member avatar

    eggsurplus Provider Affiliate

    4 years ago

    Thanks for reporting this. Upon initial testing on 7.11.18, I cannot replicate this. I have a few questions that will help to recreate what you are running intoo.

    1. Are you attempting to Mass Assign a group or to a user?
    2. Are you doing a Select All or a Select Page/specific selections? https://www.dropbox.com/s/dhb3xbdbhqqnlwc/Screenshot%202020-11-11%20at%209.46.46%20AM.png?dl=0
    3. Are there any search filters set and if so, which ones?
    4. Which columns are displayed on your Leads List View?

    Thanks! -Jason

  2. nelem member avatar

    nelem

    4 years ago

    1. Mass assign to a group
    2. It's Select All (1500 records)
    3. Search filter is for a custom relate link to Accounts. This is the join alias that is failing.
    4. The Relate field (as above), Name, Status, a custom dropdown and miscellaneous others.

  3. eggsurplus member avatar

    eggsurplus Provider Affiliate

    3 years ago

    For anyone else who is running into this, we were able to replicate this issue when doing a Mass Assign while using a search filter with a custom relate field. The issue has been fixed in the 3.1.23 release of SecuritySuite for all versions of SuiteCRM.

This case is public. Please leave out any sensitive information such as URLs, passwords, etc.
Saving Comment Saving Comment...
  • Supported Versions
  • 7.6.2 to 7.14.4
Read Our Review
Rating

  • "The add-on itself was already a must for my SuiteCRM, which was missing this very important security feature. However, what surprised me the most was ..." - Davint

    Read More Reviews

Other add-ons of interest

Glances - Integrate SuiteCRM with all your apps

The simplest way to work™. Glances integrates SuiteCRM with all your favorite workplace apps, acting as your go-to hub for real-time customer insights and personal tasks.

Featured

Users Activity Logger

Log SuiteCRM Users activities like User Login, Logout, Record Create, Update, Delete on any module with IP address of the User

Rating

Organization Chart for SuiteCRM

Organization Chart for SuiteCRM allows users to view the structure of their organization and of their customers in a beautiful chart.
Administration teams securitysuite security groups