Visit Sage CRM Main Website
About Sage CRM
Browse By Tags
Sage CRM v6.2
The Design of Web Service Applications and Performance
My hope is that if you have attended any of my presentations about the Web Services interface for Sage CRM you will have taken away with you an impression of the importance of the design of the client application and how this would affect performance. The source code for the sample application which...
2 Oct 2009
The Journal Table
I was tempted to start a new series of articles called " Mysterious Tables of Sage CRM " but since this is supposed to be a sensible library of "Hints, Tips and Tricks" I have resisted. Nevertheless, there are a few tables in the Sage CRM database that whose purpose may be obscure...
3 Sep 2018
Using Joins in Web Services
Imagine you need to retrieve information from CRM via the webservices interface; this query should combine data from multiple tables. In the COM API (ASP pages, self service, table level scripts etc) you could use the QueryObject to build the exact SQL you need. var mySQL = "SELECT Person.*,...
9 Jun 2009
Web Services, Where Clauses and Subqueries
This article follows on from a previous article " Using Joins in Web Services ". That article discussed how views that are linked into CRM and described as 'tables' in metadata can be used to provide access to data from multiple tables within a single webservice request. In that...
9 Jun 2009
Tips for Building Views: A round up of articles on views.
The following is a survey of all the different articles that have discussed creating and editing views within Sage CRM. Understanding SQL views is essential as they under pin just about every feature within Sage CRM and completely determine what can or can't be done in Reports, Marketing Groups,...
1 Jul 2009
© The Sage Group plc 2019
All Rights Reserved