{"id":752,"date":"2012-06-19T16:07:15","date_gmt":"2012-06-19T16:07:15","guid":{"rendered":"http:\/\/mahenderpal.wordpress.com\/?p=752"},"modified":"2012-06-19T16:07:15","modified_gmt":"2012-06-19T16:07:15","slug":"get-optionset-label-based-on-optionset-value-using-javascript","status":"publish","type":"post","link":"https:\/\/himbap.com\/blog\/?p=752","title":{"rendered":"Get Optionset Label based on Optionset value using Javascript"},"content":{"rendered":"

I got one requirement to fetch optionset lable based on it’s value, then\u00a0I found this post <\/a>\u00a0which helped me to write required script.\u00a0We can write a Soap request to fetch optionset metadata based on it’s metadata id (Guid for global optionset, you can capture global optionset guid from URL\u00a0through opening global optionset record). once you have guid you can write a Soap request like below, make sure to change metadataid and optionsetname<\/p>\n

\u00a0function GetOptionsetLable(_Value) {
\n\u00a0\u00a0\u00a0
\n\u00a0\u00a0\u00a0 var _ServerURL = Xrm.Page.context.getServerUrl() + “\/XRMServices\/2011\/Organization.svc\/web”;
\n\u00a0\u00a0\u00a0 var MetadaID = “xxxx-xxx-xxx…”; \/\/Optionset guid
\n\u00a0\u00a0\u00a0 var _OptionLabel = null;
\n\u00a0\u00a0\u00a0 var xmlrequest = “<s:Envelope xmlns:s=”http:\/\/schemas.xmlsoap.org\/soap\/envelope\/<\/a>“>” +
\n\u00a0\u00a0\u00a0 “<s:Body>” +
\n\u00a0\u00a0\u00a0 “<Execute xmlns=”http:\/\/schemas.microsoft.com\/xrm\/2011\/Contracts\/Services<\/a>” xmlns:i=”http:\/\/www.w3.org\/2001\/XMLSchema-instance<\/a>“>” +
\n\u00a0\u00a0\u00a0 “<request i:type=”a:RetrieveOptionSetRequest” xmlns:a=”http:\/\/schemas.microsoft.com\/xrm\/2011\/Contracts<\/a>“>” +
\n\u00a0\u00a0\u00a0 “<a:Parameters xmlns:b=”http:\/\/schemas.datacontract.org\/2004\/07\/System.Collections.Generic<\/a>“>” +
\n\u00a0\u00a0\u00a0 “<a:KeyValuePairOfstringanyType>” +
\n\u00a0\u00a0\u00a0 “<b:key>MetadataId<\/b:key>” +
\n\u00a0\u00a0\u00a0 “<b:value i:type=”c:guid” xmlns:c=”http:\/\/schemas.microsoft.com\/2003\/10\/Serialization\/”>”+MetadaID+”<\/b:value<\/a>>” +
\n\u00a0\u00a0\u00a0 “<\/a:KeyValuePairOfstringanyType>” +
\n\u00a0\u00a0\u00a0 “<a:KeyValuePairOfstringanyType>” +
\n\u00a0\u00a0\u00a0 “<b:key>RetrieveAsIfPublished<\/b:key>” +
\n\u00a0\u00a0\u00a0 “<b:value i:type=”c:boolean” xmlns:c=”http:\/\/www.w3.org\/2001\/XMLSchema”>false<\/b:value<\/a>>” +
\n\u00a0\u00a0\u00a0 “<\/a:KeyValuePairOfstringanyType>” +
\n\u00a0\u00a0\u00a0 “<a:KeyValuePairOfstringanyType>” +
\n\u00a0\u00a0\u00a0 “<b:key>Name<\/b:key>” +
\n\u00a0\u00a0\u00a0 “<b:value i:type=”c:string” xmlns:c=”http:\/\/www.w3.org\/2001\/XMLSchema”>OptionsetName<\/strong><\/b:value<\/a>>” +
\n\u00a0\u00a0\u00a0 “<\/a:KeyValuePairOfstringanyType>” +
\n\u00a0\u00a0\u00a0 “<\/a:Parameters>” +
\n\u00a0\u00a0\u00a0 “<a:RequestId i:nil=”true” \/>” +
\n\u00a0\u00a0\u00a0 “<a:RequestName>RetrieveOptionSet<\/a:RequestName>” +
\n\u00a0\u00a0\u00a0 “<\/request><\/Execute><\/s:Body><\/s:Envelope>”;
\n\u00a0\u00a0\u00a0 var req = new XMLHttpRequest();
\n\u00a0\u00a0\u00a0 req.open(“POST”, _ServerURL, false)
\n\u00a0\u00a0\u00a0 req.setRequestHeader(“Accept”, “application\/xml, text\/xml, *\/*”);
\n\u00a0\u00a0\u00a0 req.setRequestHeader(“Content-Type”, “text\/xml; charset=utf-8”);
\n\u00a0\u00a0\u00a0 req.setRequestHeader(“SOAPAction”, “http:\/\/schemas.microsoft.com\/xrm\/2011\/Contracts\/Services\/IOrganizationService\/Execute<\/a>“);
\n\u00a0\u00a0\u00a0 req.send(xmlrequest);
\n\u00a0\u00a0\u00a0 var resultXml = req.responseXML;<\/p>\n

\u00a0\u00a0\u00a0 var errorCount = resultXml.selectNodes(‘\/\/error’).length;
\n\u00a0\u00a0\u00a0 if (errorCount != 0) {
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 var msg = resultXml.selectSingleNode(‘\/\/description’).nodeTypedValue;
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 alert(msg);
\n\u00a0\u00a0\u00a0 }
\n\u00a0\u00a0\u00a0 else {
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 var oXmlDoc = new ActiveXObject(“Microsoft.XMLDOM”);
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 oXmlDoc.async = false;
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 oXmlDoc.loadXML(resultXml.xml);
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 var results = oXmlDoc.getElementsByTagName(“ExecuteResponse\/ExecuteResult\/a:Results\/a:KeyValuePairOfstringanyType\/b:value\/c:Options\/c:OptionMetadata”);
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 for (i = 0; i < results.length; i++) {
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 var _Name = results[i].selectSingleNode(‘.\/c:Label\/a:LocalizedLabels\/a:LocalizedLabel\/a:Label’).nodeTypedValue;
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 var Optionvalue = results[i].selectSingleNode(‘.\/c:Value’).nodeTypedValue;
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 if (_Value == Optionvalue) {
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 _OptionLabel = _Name;
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 break;
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 }
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 }
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 return _OptionLabel;
\n\u00a0\u00a0\u00a0 }
\n\u00a0\u00a0\u00a0 return _OptionLabel;
\n}<\/p>\n

Enjoy !!<\/p>\n","protected":false},"excerpt":{"rendered":"

I got one requirement to fetch optionset lable based on it’s value, then\u00a0I found this post \u00a0which helped me to write required script.\u00a0We can write a Soap request to fetch optionset metadata based on it’s metadata id (Guid for global optionset, you can capture global optionset guid from URL\u00a0through opening global optionset record). once you have guid you can write… Read more »<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[5],"tags":[],"_links":{"self":[{"href":"https:\/\/himbap.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/752"}],"collection":[{"href":"https:\/\/himbap.com\/blog\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/himbap.com\/blog\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/himbap.com\/blog\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/himbap.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=752"}],"version-history":[{"count":0,"href":"https:\/\/himbap.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/752\/revisions"}],"wp:attachment":[{"href":"https:\/\/himbap.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=752"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/himbap.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=752"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/himbap.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=752"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}