You’re offline. This is a read only version of the page.
Hi Experts,
do you have any sample code ? or explanation or article that i can reference?
Thanks
*This post is locked for comments
I have the same question (0)
Hi,
you can refer to below post, use the last query that provided.
[View:https://community.dynamics.com/crm/b/crmjimwang/archive/2009/03/27/get-entity-47-attribute-39-s-display-name-from-crm-database:750:50]
Language code
docs.microsoft.com/.../enable-multiple-language-support
Sample code
SELECT EntityView.Name AS EntityName, LocalizedLabelView_1.Label AS EntityDisplayName,
AttributeView.Name AS AttributeName, LocalizedLabelView_2.Label AS AttributeDisplayName
FROM LocalizedLabelView AS LocalizedLabelView_2 INNER JOIN
AttributeView ON LocalizedLabelView_2.ObjectId = AttributeView.AttributeId RIGHT OUTER JOIN
EntityView INNER JOIN
LocalizedLabelView AS LocalizedLabelView_1 ON EntityView.EntityId = LocalizedLabelView_1.ObjectId ON
AttributeView.EntityId = EntityView.EntityId
WHERE LocalizedLabelView_1.ObjectColumnName = 'LocalizedName'
AND LocalizedLabelView_2.ObjectColumnName = 'DisplayName'
AND LocalizedLabelView_1.LanguageId = '1033' <-- change the language code (LCID) accordingly.
AND LocalizedLabelView_2.LanguageId = '1033' <-- change the language code (LCID) accordingly.
AND EntityView.Name IN ('Account','Contact') <-- replace your entity name
ORDER BY EntityName, AttributeName
Please note that this is unsupported
Share
Report
All responses (
Answers (
33,628
