Browse By Tags
Home
»
All Tags
»
SQL
»
Web Services
COM
Company
correlated subquery
ERP
Integration Options
joins
Journal
Logging
Meta Data
newproduct
orders
Performance
QuoteItems
Reports
Sage 200
Sage Accpac
Sage Bäurer
Sage CRM v6.2
Sage MAS
Security
subquery
subselect
Views
vsentinel
Workflow
Blog Post:
The Design of Web Service Applications and Performance
Jeff Richards
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...
on
2 Oct 2009
Blog Post:
The Journal Table
Jeff Richards
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...
on
3 Sep 2018
Blog Post:
Using Joins in Web Services
Jeff Richards
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.*,...
on
9 Jun 2009
Blog Post:
Web Services, Where Clauses and Subqueries
Jeff Richards
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...
on
9 Jun 2009
Blog Post:
Tips for Building Views: A round up of articles on views.
Jeff Richards
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,...
on
1 Jul 2009