Browse By Tags
Home
»
All Tags
»
SQL
»
Views
»
Meta Data
ASP
Columns
COM
Company
Component
Context
custom captions
Custom Content
custom_screenobjects
Download
eWareQuery Object
Fields
joins
Library
List Block
List Page
newproduct
ntext
nvarchar
OrderItems
orders
Person
QuoteItems
translations
Web Services
Blog Post:
Adding Derived Fields in Views into Meta Data
Jeff Richards
I originally wrote about creating derived fields in a view in the article " Custom_Edits and Derived Fields Created in Views ". This discussion is a continuation of the ideas expressed in that article and will show how meta data definitions of a calculated field can be easily added into Meta...
on
30 Jun 2009
Blog Post:
More Adventures with the Library
Jeff Richards
I have been investigating the list of documents that appears under the Company tab group. This is actually part of a set of investigations into the library entity that I am working on. So there will be a few more blogs about documents and the library in the near future. I wanted to find out how to ensure...
on
31 Jan 2008
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:
Converting default ntext fields from an old install of CRM to nvarchar(max)
Sage CRM Team
This is a SQL script that will solve the problem associated with on-premise accounts that still have some ntext fields in their database from older versions of CRM. The ntext fields do not allow some of the actions that are used in the views of CRM, DISTINCT being an example of one of these commands...
on
11 May 2018