Bagikan melalui

How are optionsets stored in CRM 2011 DB

  • Artikel

I ran into a question while working on a project on how Option sets were stored in CRM 2011. I started looking into the DB and it looks pretty straight forward. Any option sets including the Global and non Global(I guess you could call them that) are stored in three tables:

1. OptionSetIds - This table contains just a column which contains a unique identifier for each new OptionSet that you create.

2. MetadataSchema.AttributePicklistValue - OptionSet Values are primarily indicated by the value stored in this table. It is stored in the Value column in this table.

3. MetadataSchema.LocalizedLabel - This is where the Option Set Label Value is stored. Just matchup the AtributePicklistValueId in MetadataSchema.AttributePicklistValue against the ObjectId in MetadataSchema.LocalizedLabel/

 

This breakup allows for localization of the OptionSet Labels........