Skip to main content

Get Option Set Name in Dynamics CRM

Get Option Set Name in Dynamics CRM.


We can retrieve Option Set name of dynamics CRM entities using StringMap entity.

StringMap entity: Stringmap entity basically used in MSCRM for storing the details of Option Set Fields exists in an organization. It contains all the data (Attribute Name, Option Set name, option value, option name, Object Type Code) of option set.

How to get Option Set Name?

We can simply join our entity with String Map entity and get name for option set fields.

Example: We want to retrieve all option set name of Case Priority.
Option Set Values without using Stringmap entity.

Script:
Query: select TicketNumber,prioritycode AS Priority
from Incident

Output:


Option Set Values using Stringmap entity.

Script:
select TicketNumber,prioritycode AS PriorityCodeValue , SM.Value AS PriorityCodeName
from Incident AS I
left join StringMap AS SM on I.PriorityCode=SM.AttributeValue
where SM.AttributeName='prioritycode' and SM.ObjectTypeCode='112'

Output:


How to get entity ObjectTypeCode?

Script:
select
OriginalLocalizedName,OriginalLocalizedCollectionName,Name,ObjectTypeCode
from EntityView order by ObjectTypeCode



Why entity ObjectTypeCode is required?
We can create global option set and use them in multiple entities so if we are required to get entity specific values then we need to provide ObjectTypeCode.









If you have further queries/seek clarification, please do let me know. 







Also, please do not forget to share your valuable feedback. It means a lot to me.









1 Percent better Every day.

Labels:

Comments

Post a Comment

Popular posts from this blog

IPLUGIN INTERFACE IN DYNAMICS 365 PLUGINS

IPLUGIN INTERFACE IN DYNAMICS CRM PLUGINS The first and mandatory Interface we require to start plugin is IPlugin Interface. What is IPlugin Interface? IPlugin is the base interface for plugins in Dynamics CRM. After Adding SDK reference the first step we need to do is to inherit IPlugin interface. We can inherit it by adding : IPlugin with our plugin class name Example - public class MyPlugin : IPlugin It is available at Namespace:      Microsoft.Xrm.Sdk Assembly :    Microsoft.Xrm.Sdk (in Microsoft.Xrm.Sdk.dll) Syntax for Iplugin public interface IPlugin IPlugin contains one method i.e Execute , Since if we are inheriting any interface in our code, we need to implement or we need to provide definition to all its method. So it is mandatory to define Execute method. Syntax for Execute method public void Execute(IServiceProvider serviceProvider) Parameters for Execute method The parameter we pass in Execute method is type of IServic...
1 comment
Read more

HOW TO START DEVELOPING A PLUGIN IN DYNAMICS CRM

How to Start Developing a Plug-in 1. Download CRM SDK. This will provide you all the information, required SDK assemblies, and many helpful samples. SDK Download Link - ( https://www.microsoft.com/en-in/download/details.aspx?id=50032 ) 2. Set up your plug-in project in Visual Studio. This will be a .NET Framework class library. 3. Add References. At a minimum, you will need Microsoft.Xrm.Sdk, obtained from CRM SDK. 4. Extend the class from Microsoft.Xrm.Sdk.IPlugin 5. Write your code 6. At the project, sign the assembly. This is required in order to be able to deploy the plugin. 7. Now you can go to location SDK and find Plugin Registration Tool in SDK. 8.Login to your Organization. 9. We will create a new assembly for our brand new plugin code , (we will discuss all aspects of Assembly and Step Registration in my upcoming blog. How to register plugin in Dynamics CRM using Plugin Registration Tool.) 10. Now, We will register the...
1 comment
Read more