Posts

Showing posts from February, 2016

Change Display text of Currency lookup field with Currency Code in Dynamics CRM 2015/16 using JavaScript

Call the Below Function onLoad & On-change Event. // JScript source code function ChangeCurrencyLookUpDisplayValue() {     debugger;     var lookupData = new Array();     var lookupItem = new Object();     var lookup = Xrm.Page.data.entity.attributes.get("transactioncurrencyid");     if (lookup != null) {         var displayvalue = '';         var xmlText = '';         xmlText += "<s:Envelope xmlns:s=\"http://schemas.xmlsoap.org/soap/envelope/\">"; xmlText += "<s:Body>";         xmlText += "<Retrieve xmlns=\"http://schemas.microsoft.com/xrm/2011/Contracts/Services\" xmlns:i=\"http://www.w3.org/2001/XMLSchema-instance">";         xmlText += "<entityName>transactioncurrency</entityName>";         xmlText += "<id>" + lookup.getValue()[0].id + "</id>";         xmlText += "<columnSet xmlns:a=\"http://

Fetch XML Condition to SQL WHERE

Advanced Find Operator Fetch XML Operator FetchXML Filter SQL Where condition Equal eq < condition   attribute = " firstname " value = " John "   operator = " eq " /> WHERE  firstname  =   'John' Not Equal ne < condition   attribute = " firstname " value = " John "   operator = " ne " /> WHERE  firstname ! =   'John' Contains like < condition   attribute = " firstname " value = " John "   operator = " like " /> WHERE  firstname  LIKE   '%John%' Does Not Contains not-like < condition   attribute = " firstname " value = " John "   operator = " not like " /> WHERE  firstname  NOT LIKE   '%John%' Begins with like < condition   attribute = " firstname " value = " John% "   operator = " like " /> WHERE  firstnam