Category Archives: Tables

Adding Secondary Entity for Primary Entity

It is possible to customize Sage CRM in different ways, to meet user requirement. There are many customization option in Administration.  So in this Blog we are going to see how to create a secondary Entity for Standards Entity. Sometime if organization is using Opportunity entity to store all of their Projects in Sage CRM. It… Read More »

Enhance a Custom entity list for loading results faster

Every new version of Sage CRM has provided with some or the other new features which has improved system stability, user experience, ease in third party apps integration and so on. Sage CRM 2018 R2 has come up with a new feature related to Custom entity, which has helped to load custom entities list faster.… Read More »

How to Exclude Auto-Opportunities created in Sage CRM?

Sage CRM’s Opportunities is the heart of every potential sale done with the Customer. These opportunities further helps to track/maintain the Quotations and Orders raised against the Sale. However, CRM’s feature of allowing the Users to create direct Quotes or Orders in CRM is also not left unnoticed, which can help the Users to maintain… Read More »

Get Size of all Tables in CRM Database

For any database driven application, it is very important that the database must be optimized to the best so as to deliver higher performance. As the data volume in database increases, load on the system also increases which affects the performance on the system which in turn affects the client’s business. For business application like… Read More »

Table Level Scripts Logging and Performance

In SageCRM, Table level script can be used for replicating SQL trigger like functionality.  Table level scripts help us handle the data update events properly and do corresponding actions within SageCRM. The beauty of it is we can use SageCRM API and write server side JavaScript like functionality to function similar to that of triggers.… Read More »

Sage CRM Database Maintenance

Database is the most important part of any application. Being business software, Sage CRM handles very delicate data and it is necessary to maintain this data properly in order to insure integrity and improved system performance. New Stuff: Confirm if your Sage CRM system has actually expired There are many ways to enhance the performance… Read More »