Posts

JavaScript WebAPI [Xrm.webApi]

By
In this blog we will see usecase of Xrm.WebApi. Generally, it is used to do CRUD operation in dynamics CRM. Most of the times we will be using retrievemultiple, retrievesingle and updaterecord.All these web api's are asynchronous, that means once we execute api, it wiill not wait for response. It will execute remaining code till we get response from api. The sample code for webapis can be generated by Dataverse REST Builder tool from xrmtoobox.  We will see below use case of WebApi 1. Xrm.WebApi.retrieveRecord -       To retrieve single record      Parameters - entityname, RecordId, OdataQuery[Select] 2. Xrm.WebApi.retrieveMultipleRecords -      To retrieve the record based on condition      Parameters - entityname, odataQuery [Select, filter] 3. Xrm.WebApi.createRecord -       To create record      Parameters - entityname, data 4. Xrm.WebApi.updateRecord -      To...
Post a Comment
Read more

JavaScript - Show-Hide/ Lock-Unlock/ Required-NotRequired

By
JavaScript syntax to show Hide different controls :  function showHide(executionContext) { var formContext = executionContext.getFormContext(); //showHide field formContext.getControl("new_field").setVisible(false); formContext.getControl("new_field").setVisible(true); //showHide tab formContext.ui.tabs.get("tab_tabname").setVisible(false); formContext.ui.tabs.get("tab_tabname").setVisible(true) //showHide section formContext.ui.tabs.get("tab_tabname").sections.get("sectionName").setVisible(false); formContext.ui.tabs.get("tab_tabname").sections.get("sectionName").setVisible(true); //ShowHide related entity from related section var navItem = formContext.ui.navigation.items.get("Courses"); if (navItem) { navItem.setVisible(false); } } JavaScript Syntax to lock-unlock fields - function lockUnlock(executionContext) { var fo...
Post a Comment
Read more

Most Used JavaScript Syntax used in MS CRM

By
In this blog we will see how we can retrieve different data types fields values in MS CRM using JavaScript. Different types of data types in MS CRM: Single Line of Text Option Set (Dropdown) Two Options (Radio Button) Image Whole Number Floating Point Number Decimal Number Currency Multiple Lines of Text Date and Time Lookup  Single or Multiline Field :  var name = formContext.getAttribute("new_name").getValue(); formContext.getAttribute("new_name").setValue(); Option-Set Field :  int value = formContext.getAttribute("new_type").getValue(); var optionsetText = formContext.getAttribute("new_type").getText(); formContext.getAttribute("new_type").setValue(100); //100 will be the optionset value Multi-Select Option-Set Field :  var multiselectValueArr = formContext.getAttribute("new_multiselect").getValue(); formContext.getAttribute("new_multiselect").setValue([100, 200, 300]); Two-Option Field :  var value = formConte...
Post a Comment
Read more

Bulk insert CRM Data into SQL table using sqlbulkcopy

By
Image
This blog will explain how we can bulk insert any source data [e.g. MS CRM data] into SQL table using C# code. We will follow below steps:  We will create DataTable in C# with same table name and column names of SQL table  Retrieve source data that needs to be retrieved Add retrieved data from source into DataTable Use SQL Connection and sqlBulkCopy to bulk insert source data into SQL First we will create DataTable with same column name available in SQL table For creating DataTable use below syntax: public static DataTable ActionableAudit() { DataTable actionableAudit; // Create a new DataTable. actionableAudit = new DataTable("ActionableAudit"); actionableAudit.Columns.Add(new DataColumn("ChangedOn", typeof(DateTime))); actionableAudit.Columns.Add(new DataColumn("CreatedBy", typeof(string))); actionableAudit.Columns.Add(new DataColumn("CreatedById", typeof(Guid))); return actionableAudit } After creating Dat...
Post a Comment
Read more

Most Used Plugin Syntax in Dynamics 365 CRM

By
Image
We always get requirement which can not be possible using OOB features of CRM and hence we move to the plugin to achieve such requirements. Whenever we need to retrieve field value from plugin, we always check whether field contains value or not by using if else block or ternary operator which makes code lengthy and not readable. In this blog, we will see how to efficiently retrieve field values of different data types. //Single Line Of Text {Defualt Value = null} string businessWebsite = account.GetAttributeValue<string>("new_website"); Console.WriteLine($"Single Line Of text : {businessWebsite}"); //get optionset text string cohort = account.Attributes.Contains("new_type") ? account.FormattedValues["new_type"] : ""; //Optionset {Defualt Value = null} int? customerCohort = account.GetAttributeValue<optionsetvalue>("new_type")?.Value; //currency {Defualt Value = null} int? mostRecentACR = (int?)account.GetAttr...
Post a Comment
Read more

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

By
Image
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: "Value": This column stores the string value assigned to each picklist option. "AttributeName": This column contains the logical name of the attribute associated with the picklist values. "AttributeValue": This column stores the numeric value assigned to each picklist option. Numeric value assigned to picklist option is unique. "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' /> <attribut...
Post a Comment
Read more

Use of aggregate, groupby in fetchxml query

By
In Microsoft Dataverse, FetchXML  includes grouping and aggregation features that let you calculate sum, average min, max and count. groupby is used to get data from CRM and group it based on particular field value. To use group-by we need to use aggregate. e.g.; If we want to get group accounts based on country and we want count of those country in descending order then we will use fetchXML like below in c#. string accountNumber = "ANO10052023"; string fetchXML = @"<fetch aggregate='true' distinct='false' mapping='logical'> <entity name='account'> <attribute aggregate='countcolumn' alias='country_count' name='new_country'> <attribute alias='new_country' groupby='true' name='new_country'> <order alias='country_count' descending='true'/> <fi...
Post a Comment
Read more