Share
ReportHi Experts,
do you have any sample code ? or explanation or article that i can reference?
Thanks
*This post is locked for comments
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
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
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,235
Most Valuable Professional
#3
nmaenpaa
101,156
All responses (
Answers (