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 »

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 »

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 »

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 »

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 »

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 »