Thursday, 9 May 2013
How to get OptionSet values using SQL?
Obtaining a list of option values for a MS CRM 2011 OptionSet is pretty simple, especially if you plan to do this via the CRM Web service API. However a requirement may arise where you may want to do this using direct SQL against the Organization database.
By default on the account entity there are several address fields, and one in particular is the Address Type picklist which is used to categorize the type of address stored for this account. Using this field as an example, the following SQL Query can be used to obtain a list of all options available to that field:
at May 09, 2013
When installing the Srs Data Connection (Microsoft Dynamics CRM Reporting Extensions), you may have experienced the following error: ...
When working with Microsoft Dynamics CRM, one of the most common tasks undertaken is to m ap real life business processes and to automate ...
Hopefully you are fortunate enough to never experience this in the field, however when some smart aleck decides to add the CRM App Pool ser...
An exciting new feature of CRM 2011 is the introduction of a REST endpoint which you can use to perform oData based queries against. The lo...