We recently upgraded MySQL from version 5.7 to 8.0.41. Post-upgrade, we have observed a noticeable improvement in overall query performance. However, we are encountering a significant performance issue, specifically when accessing list views in modules…
Context:
Our database contains orphaned records (e.g., Tasks, Notes) where the parent_type and parent_id reference deleted parent records. These orphaned records, some over five years old, need cleanup to improve database efficiency.
Objective:
…
The article " Extending Sugar Logic " provides some guidance on building a Sugar Logic function. We would like to add a dependency to check our Permissions module. Is it possible to use `App.api.call("read")` to return a boolean indicating whether the…
We have been using Sugar for more than 6 years. We have audit log records that go back to the start of our use of Sugar. The Archive Data tool does not have the ability to archive audit tables. What is the best practice to remove older data from these…
How can I add an index on a field of type textarea? I have added the index with field(32). Which is the part of the field I'd like to index. However, each time we do a Quick Repair and Rebuild. Sugar finds the index but wants to remove and re-add the…
Hello Good Day!
I am currently exploring the SugarCRM connectors feature in SugarCRM. I followed the configuration provided by SugarCRM, and after the configuration, I setup an external account. However, I wasn't able to import contacts from my Google…
If a user is deactivated via SSO; Sugar doesn't update their User account to be Inactive. Is there a method to deactivate the user if they are removed from access in SSO/SAML?
Hi Everyone.
I am trying to create a calculated field and it is giving me an issue can you guys see any issue. I have the formular in english and the one in code under. I keep getting a parentheses issue
Formular
Unit Cost (CAD) x ( 1 / ( standardwidth…
Hello what i'm trying to achieve here is to make an API call and use the retrieved values to generate a dynamic multi-select field and be able to save selected options. I have used HOWTO: Have a dropdown field that get's it's options from a function as…
Step 1. Select "Create" from the Quotes Module ListView to create a new record. OR Step 2. Select "Create" (the + button) from a related module (Accounts) in the sub panels. When the pop up window shows (the cached version of the new Quote record), I…
I am trying to disable a button in the Save button dropdown in a module's record view. I would like to do that for just that single button without overriding the entire file, so I thought I would create and extension file for the record view and unset…
Hi I am not able to add more than 40 product in quotes sugarcrm Enterprise 7.6. if I add forcefully then all product got deleted and quotes got crashed. is any limitation in quotes module for product. please help me out Thank you
