CRM 2013 - Where can find the custom, global option set value in MS SQL database RRS feed

  • Question

  • Hi, where can I find these values ?


    Friday, June 20, 2014 7:51 AM

All replies

  • Once the global option is used in an attibute, they're in the StringMapBase table. Before they're used, you can use the following query:

    select os.Name, l.Label from AttributePicklistValueAsIfPublishedLogicalView av
    join OptionSetAsIfPublishedLogicalView os
    on av.OptionSetId = os.optionsetid
    join LocalizedLabelAsIfPublishedLogicalView l
    on l.ObjectId = av.AttributePicklistValueId
    where os.IsGlobal = 1 and os.IsCustomOptionSet = 1
    and l.ObjectColumnName = 'DisplayName'

    Microsoft CRM MVP - http://mscrmuk.blogspot.com/ http://www.excitation.co.uk

    Friday, June 20, 2014 9:14 AM
  • Thanks

    Can I modify these values directly in Data base ?

    Friday, June 20, 2014 9:32 AM