Get option-set value from text and get option-set text from Value using plugin

By

In this blog we will discuss the use of StringMap table to get option-set metadata in our CRM plugin.

StringMap table holds the metadata information of option-sets.

The StringMap table contains the following important columns:

  1. "Value": This column stores the string value assigned to each picklist option.
  2. "AttributeName": This column contains the logical name of the attribute associated with the picklist values.
  3. "AttributeValue": This column stores the numeric value assigned to each picklist option. Numeric value assigned to picklist option is unique.
  4. "ObjectTypeCode": Object type code of entity for which attribute belongs.
Code snippet to get option-set Value from Text:
static int? GetOptionSetValueFromText(IOrganizationService service, string optionSetSchemaName, string optionSetText, int objectTypeCode)
{

	string fetch = @"<fetch>
			<entity name='stringmap' >
			<attribute name='value' />
			<attribute name='objecttypecode' />
			<attribute name='attributevalue' />
			<filter type='and' >
			<condition attribute='objecttypecode' operator='eq' value='" + objectTypeCode + @"' />
			<condition attribute='attributename' operator='eq' value='"+optionSetSchemaName+ @"' />
			<condition attribute='value' operator='eq' value='"+optionSetText+@"' />
			</filter>
			</entity>
			</fetch>";

	EntityCollection stringMapCollection = service.RetrieveMultiple(new FetchExpression(fetch));
	int? optionSetValue = null;
	if (stringMapCollection.Entities.Count > 0)
	{
		optionSetValue = stringMapCollection.Entities[0].GetAttributeValue<int>("attributevalue");
	}
	return optionSetValue;
}
Code snippet to get option-set Text from Value:

we can use simple formatted Values syntax to get the option-set Text
string type = account.FormattedValues["new_assignmenttype"];
Code snippet to get option-set Text from Value using stringmap table:
static string GetOptionSetTextFromValue(IOrganizationService service, string optionSetSchemaName, int optionsetValue, int objectTypeCode)
{
	string fetch = @"<fetch>
			<entity name='stringmap' >
			<attribute name='value' />
			<attribute name='objecttypecode' />
			<attribute name='attributevalue' />
			<filter type='and' >
			<condition attribute='objecttypecode' operator='eq' value='" + objectTypeCode + @"' />
			<condition attribute='attributename' operator='eq' value='" + optionSetSchemaName + @"' />
			<condition attribute='attributevalue' operator='eq' value='" + optionsetValue + @"' />
			</filter>
			</entity>
			</fetch>";

	EntityCollection stringMapCollection = service.RetrieveMultiple(new FetchExpression(fetch));
	string optionSetText = null;
	if (stringMapCollection.Entities.Count > 0)
	{
		optionSetText = stringMapCollection.Entities[0].GetAttributeValue<string>("value");

	}
	return optionSetText;
}

Comments

Post a Comment

Popular posts from this blog

Accessing Fields on QuickView Form through javaScript

By
QuickView form is template to view information about related entity record within a form for another entity record. Sometimes you need to access data from QuickView form for performing business logic. In order to get QuickView form in js you can use following syntax :  Syntax :  formContext.ui.quickForms.get(arg); Following is the example how you can access field from QuickView Form :  getAttributeValueFromQuickViewForm: function(executionContext) { var formContext = executionContext.getFormContext(); var quickViewControl = formContext.ui.quickForms.get("quickFormName"); if (quickViewControl != undefined) { if (quickViewControl.isLoaded()) { //not necessary to use this condition quickViewControl.getControl("new_name").getAttribute().setValue("Abhishek Dhandare"); //to get value used below syntax quickViewControl.getControl("new_type").getAttribute().getValue(); //perform your ...
Read more

ADF - (Part 2) Integrate Data From CRM to External system

By
Image
 In this blog we will integrate data from Microsoft Dynamic CRM to External system's SQL databse. we are going to integrate Account and Contact tables from CRM to external system Before starting with this, you should have following things :  1. Microsoft Dynamics CRM Environment 2. Microsoft SQL Server Management Studio Software(SSMS) 3. Azure Portal account First connect to your SQL server in SSMS and create Account and Contact Table. You can use following query to create table CREATE TABLE Account( [AccountId] [uniqueidentifier] NULL, [AccountName] [varchar](200) NULL, [CreditHold] [int] NULL ) CREATE TABLE Contact( [ContactId] [uniqueidentifier] NULL, [name] [varchar](200) NULL, [MobileNumber] [varchar](50) NULL, [FirstName] [varchar](200) NULL, [LastName] [varchar](200) NULL, [AccountID] [uniqueidentifier] NULL, [AccountName] [varchar](200) NULL ) After creating tables, Navigate to Azure Data factory in azure portal, and Create Dataset for your source and de...
Read more

ADF - (Part3) Integrate Data From CRM to External system Using Stored procedure

By
Image
 In this blog we will see how we can use stored procedure to transform our data in ADF.  For better understanding you can check my previous blog for better understanding. When we integrate CRM data to external system SQL, then for  Option-Set fields present in CRM, we get Option-Set values and not Text value. eg. we have Credit Hold option set field in CRM and after integration we are getting option set value. To solve this problem we will create OptionSetMetaData table in SQL which will store details about option-set fields SQL query to create OptionSetMetaData table CREATE TABLE [dbo].[OptionSetMetadata]( [ID] [uniqueidentifier] NULL, [EntityName] [varchar](50) NULL, [OptionSetFieldName] [varchar](50) NULL, [OptionSetText] [varchar](50) NULL, [OptionSetValue] [int] NULL ) //To Insert Records in sql Table Insert Into OptionSetMetadata Values (NEWID(), 'account', 'Credit Hold', 'Yes', 1) Insert Into OptionSetMetadata Values (NEWID(), 'account...
Read more