locked
how to retrieve label names from ms crm 2011 database. RRS feed

  • Question

  • Hi All,

    Could you please help us in getting the all label names entity wise from ms crm 2011 database.

    we can able to retrieve all label names by using below query.

    select * from LocalizedLabelView lv where lv.LabelTypeCode=8

    but we can't able to link these lable names with the corresponding entities. Could you please help us on this.

    Also please help us, how to get all lable names entity wise using crm service.

    Thanks in advance.

    Best Regards,

    Prasanth.


    prasanth : MS CRM Developer.

    Friday, July 19, 2013 12:41 PM

All replies

  • Please use RetrieveAllEntitiesRequest.

    Also check the below url for  more info.

    http://msdn.microsoft.com/en-us/library/microsoft.xrm.sdk.messages.retrieveallentitiesrequest.aspx

    Thanks.

    If this post answers your question, please click "Mark As Answer" on the post and "Mark as Helpful"

    Friday, July 19, 2013 1:54 PM
  • Try:

    select 
     e.Name as EntityName
    ,a.Name as AttributeName
    ,l.Label as AttributeLabel
    from EntityView e
    inner join AttributeView a on e.EntityId=a.EntityId
    left join LocalizedLabelView l on a.AttributeId=l.ObjectId and l.LabelTypeCode=1 and l.objectcolumnName='DisplayName'
    order by e.Name,a.Name
    Friday, July 19, 2013 2:03 PM
  • I want to retrieve the records with label type code 8 and corresponding entity names.

    prasanth : MS CRM Developer.

    Monday, July 22, 2013 6:48 AM
  • Those are the customized form labels and you will need to parse the xml in the FormXml column in the SystemForm table to work that out.
    Monday, July 22, 2013 8:46 AM
  • Thank you very much for the quick response.

    Could you please provide some detailed process if possible, how to achieve this functionality. that is relating each label to the entity. and retrieving all labels entity wise.


    prasanth : MS CRM Developer.

    Monday, July 22, 2013 9:15 AM