Skip to main content

Posts

Showing posts from December, 2019

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 ...