Sign in
Microsoft.com
 
Microsoft
 
 
 

locked
Table in which the form customized labels will get stored in CRM 2011? RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    Team,

    I have a requirement like below. Some time back we created an entity in CRM 2011 with 5 attributes. After that we have placed all these attributes on form.  After some time one of my developer just changed the label on the form for a particular attribute in stead of changing the display or Schema name in the Entity attribute level.

    Now I want to find out what other places team made these kind of changes? How to find these. in which table the form customized labels will get stored in CRM 2011? Please give your inputs on this.

    Thank you,

    Babu

    Thursday, February 13, 2014 10:17 AM

All replies

  • Question
    Sign in to vote
    0
    Sign in to vote

    Try something like this against your target organisation db

    select	distinct e.LogicalName, a.name, a.IsCustomField, l.Label
from	MetadataSchema.Attribute a 
		left join MetadataSchema.Entity e on a.EntityId = e.EntityId
		left join MetadataSchema.LocalizedLabel l on a.AttributeId = l.ObjectId
where	l.ObjectColumnName = 'DisplayName'		
order by e.LogicalName

    Eric UNG [Senior Analyst Programmer :: Sydney, Australia]

    Thursday, February 13, 2014 10:42 AM