Where does Microsoft Dynamics CRM store OptionSet values

Where does Microsoft Dynamics CRM store OptionSet values

I found myself looking in a Microsoft Dynamics CRM database for the place where “Option sets” are stored, turns out there is a simple view for that.

SELECT [FilteredViewName]
      ,[AttributeName]
      ,[AttributeValue]
      ,[Value]
      ,[DisplayOrder]
      ,[LangId]
  FROM [FilteredStringMap]
  where AttributeName like 'new_%'

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.