Tag Archives: SQL

New Features and Enhancements in Sage CRM 2023 R1

Sage CRM, a popular customer relationship management solution, has undergone an exciting transformation with its latest release, Sage CRM 2023 R1. Packed with numerous new features and enhancements, this version promises to streamline workflows, boost productivity, and enhance customer experience like never before. In this blog post, we will delve into some of the key… Read More: New Features and Enhancements in Sage CRM 2023 R1 »

Easy Steps to Find out Field Reference in Sage CRM

Sage CRM has the ability to customize in a different way as user need. Users can add multiple fields on screen as per requirements. In Sage CRM there are different custom tables that stores data of fields, screen or list that are created. But it becomes difficult to find the field reference i.e. field belongs… Read More: Easy Steps to Find out Field Reference in Sage CRM »

Auto update opportunity stage using escalations rules

Opportunities are a very important aspect of sales revenues in any business as they help us to track orders, sales forecast and quotations against every sale. As we know opportunity goes through various stages in Sage CRM. In this blog, we will discuss how to auto update opportunity stage from Proposal Submitted to Proposal Approved… Read More: Auto update opportunity stage using escalations rules »

How to bind Custom List in Dot net using Select SQL

As we know we can create list in Sage CRM which can be attached to a table or view. Using .net technology, we can filter the list with specific record with certain condition given to it. But, what if we need to bind the custom list with Select SQL statement. This blog article will help… Read More: How to bind Custom List in Dot net using Select… »

SQL Error while trying to add column in company grid

Hi folks! As we all know that CRM contains large number of screens, lists, grids, etc. CRM has respective tables to maintain the same. Through these blog/article I will explain you a scenario which I faced while working in one of the project and how I resolved a very strange issue. Related Stuff: Quick look… Read More: SQL Error while trying to add column in company grid »

Using Primary Key Column of an Entity to Search

Sage CRM Search screens allow Users to search data by any criteria or a combination of criteria on the Search screen. In this blog post, we will explain you how to add a Primary Key of a column of any entity to entity search screen. New Stuff: View Fusion Charts on Sage CRM Interactive Dashboards… Read More: Using Primary Key Column of an Entity to Search »

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: Get Size of all Tables in CRM Database »

Hash fields in Workflow Execute SQL Statements

Workflow is one of the powerful features of SageCRM. We can define workflow Rules for systematically updating data for the entities through workflow. Every rule must be associated with set of actions. Sage CRM Workflow has several workflow actions that can be configured for any workflow rule as shown in below diagram. New Stuff: Implementing… Read More: Hash fields in Workflow Execute SQL Statements »

SageCRM Record Id generation old and new methods

How you design your database has huge effect on how your system performs. Primary key, foreign key constraints help to keep the tables linked to each other and store the data in unified manner. From long time SageCRM has followed strategy of generating primary keys through stored procedures rather than relying on the inbuilt primary… Read More: SageCRM Record Id generation old and new methods »