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

  • Question

  • 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

  • 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