Monthly Archives: January 2014

Retrieving CRM Option Set values from SQL #tips #crm #sql #optionsets

Getting the Option Set Values from SQL

C Sharp & SQL Tips and Tricks

Today I needed to get a list of all the options sets for a particular option set. One option would be to do a DISTINCT query on the filtered view but that might not return me all of the values as some might not be used.

I did a quick search and found out that the option set values are stored in the FilteredStringMap view, here is the query:

View original post