Tag Archives: SQL

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 »

Change Default Language/ Date Format in SQL

Usually in SQL, date gets saved as ‘2009-07-27 00:00:00.000’ but when we run the query or call date from any application the SQL gives us the date in desired format like ’07/27/2009’. How does it work? SQL has set of formats according to the different languages for example ‘British’, ‘Dutch’, ‘German’, ‘English’ etc. By Default… Read More »