Category Archives: SQL

How to get SQL Query of Groups created in Sage CRM

In Sage CRM, Groups feature allows you to create, edit, and save lists of people, companies, leads, cases, opportunities, quotes and orders based on defined filter criteria. Groups are based on the SQL views generated by queries. The views that are used to create group’s needs to be designed such that each row should return… Read More »

Generate Unique Reference Number in Custom Field using Workflow

In previous blog, we have seen that how we can call stored procedure from workflow action. Now, I will explain you, how we can use the same feature to generate Unique Reference Number for other entities like Case, Quote or Order. New Stuff: Prevent the Non-Admin users from adding duplicate records in Sage CRM We can… Read More »

Control Access Rights of Entity tabs in Sage CRM

Sage CRM has a complex and sophisticated Security mechanism implemented as automatic alteration of the SQL used to fetch either the application data to the screen or the metadata that controls the availability of features. One such feature is related to the various Entity Tabs which displays the List or Screens for Users. Since not… Read More »

Hide Merge to PDF option from New Menu in Sage CRM

As you know, Sage CRM 7.3 came with a feature of creating PDF merged documents. You can create PDF merged documents using “Merge To PDF” option available in New Menu. Also, you can do the same from workflow also. Please refer below blog link for the same. Related Post: Merge to PDF through workflow in Sage… Read More »

How to Make Document Visible for All Users

As you all know Sage CRM comes with bundle of standard functionalities which fulfill user requirements such as Email, SMS, Reports and documents etc. By default CRM put some restrictions on this functionalities like while merging a document against any entity we need to fill some details on screen, and based on that details document… Read More »

Information on Database Configurations in Sage CRM

Upon installing Sage CRM apart from selecting the installation path we are required to provide instance name and SQL server connection details to proceed further with installation. Whatever the instance name that we provide upon installation, the installation process will create a database in SQL with same name and required tables in the database. The… Read More »

How to modify SQL Logging Level of CRM from Registry

As we know CRM logs plays a vital role in identifying the cause of any errors and act as helping hand for implementers and developers. User can check logs which are divided into different categories such as SQL Logs, .Net Logs, System logs and so on. Along with this different logging level can be defined… Read More »

Meaning and Usage of “#” symbol in Sage CRM

Hi Folks! In standard CRM escalation conditions you must have seen “#” symbol used to get certain values on run time. Through this article I would be explaining you in detail about the usage of “#” symbol. New Stuff: How to bind Custom List in Dot net using Select SQL The #Codes are a set of… Read More »