Tag Archives: SQL

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 »

Identity increment in CRM tables

Primary keys in SQL tables allow us to uniquely identify the rows. These keys also allow us to establish the relationship between tables based on foreign key-primary key concept. Though we can have different id field names in CRM tables, the standard primary key feature is well maintained with field names like “_” (e.g. Case_CaseId).… Read More »