Browse By Tags
Home
»
All Tags
»
Views
»
Web Services
COM
Company
eWareQuery Object
Fields
Graphs
joins
Logging
Meta Data
newproduct
OrderItems
orders
Performance
Person
QuoteItems
quotes
Reports
Security
SQL
uom
uomfamily
vsentinel
Workflow
XML
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:
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:
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