20
Hi,
I have created the custom field in an entity, but i am unable to get column in database server with the same name.\
Also, using the 2011 onpremise version.
*This post is locked for comments
New fields always have a prefix based on the publisher. Are you including the prefix as part of the schema name? Have you published the customization?
For custom entity, the EntityBase table will have only a few columns.
Check that column name in YOURENTITYNAME_ExtensionBase sql table
When you create the custom field in CRM, a column of the same name will be created in the SQL database. In CRM 2011, this new column will be created in the <entityname>_ExtensionBase table (for reference, from CRM 2013 onwards, the _ExtensionBase tables have been removed)
in crm 2011 custom fields are added to the extension table and not to the main table
if the field for example is on contact entity, the table with standard field is called
ContactBase
and the table with the custom field is called
ContactExtensionBase
HOWEVER
you should use the Filtered Views (so something like SELECT * FROM FilteredContact) instead of the direct tables
#1
André Arnaud de Cal...
292,516
Super User 2025 Season 1
#2
Martin Dráb
231,403
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
