-
Continue reading →: SQL Query to fetch top 1 record from each group
I have a SQL table ‘Market’ with 3 Groups (i.e., Fruits, Vegetable and Meat) and below is the data My requirement is From each group fetch the top 1 item by ‘Priority’ column (i.e., Priority = 1) like below Name Group Priority Apple Fruits 1 Fish Meat 1 Potato Vegetable 1 The…
-
Continue reading →: Create an Organization with custom Currency Code as Base Currency
Recently I was creating a new CRM Organization for “Mauritius” Customer and I had to set Base Currency as “Mauritius Rupee (MUR)”. But MUR currency code was not there in the list of available CRM currency codes. In these scenarios, we can type the Currency Code, Currency Name and Currency…
-
Continue reading →: Loading dependent jscript libraries in ribbon button’s execution CRM 2013
In CRM 2011, To load the dependent Jscripts on execution of ribbon button command actions We can add the dependent script as a Library in the “Javascript Command” and pass “isNaN” as Function Name (Refer my existing article) In CRM 2013, I observed a slight change in the execution w.r.t the order. The…
-
Continue reading →: Can only generate one of classes or data sets – Error with Xsd.exe tool
I was getting below exception when I try to generate a class file from my XML schema using command (xsd “mySchema.xsd”) Reason & Fix – Reason is, Xsd tool unable to determine whether to generate Dataset or Class Fix is, pass argument “/c” to generate Class or “/d” to generate…
-
Continue reading →: How to debug XAML Workflows when invoked remotely
Assume you have a XAML workflow created using WF designer and you trigger this workflow from a console application which is in another server. Below are the steps to debug Install “Workflow Manager Tools” After installation you can find a folder under “C:\Program Files (x86)\Workflow Manager Tools\1.0” Open “Microsoft.Workflow.TestServiceHost.exe.config” using…
-
Continue reading →: Quick Create Forms – CRM 2013
‘Quick Create’ form is the latest addition in CRM 2013 new set of features. ‘Quick Create’ form enable you to create records quickly by just filling the key information (i.e., fields) using global ‘Create’ button. In this article I would like to provide few key points about ‘Quick Create’ form To enable…
-
Continue reading →: Check network performance using CRM Diagnostics page
With the release of CRM 2011 UR 4, CRM built a diagnostics page to check network performance between the client and server. Using diagnostics page we can check the bandwidth, latency and JavaScript Rendering performance. This is a quick and easy way to identify the network performance without having to install…
-
Continue reading →: Site map changes after Activity Feeds solution import
In our CRM application we removed ‘Sales’ tab as per a business requirement. Later as part of another requirement we installed ‘Activity Feeds’ managed solution in our application. To our surprise ‘Sales’ tab resurfaced only with “What’s New” link. Fix – To remove ‘Sales’ tab we followed below steps…
-
Continue reading →: Get nearby locations using Bing maps – WP 8
Using ‘Bing Maps Task’ we can get the nearby locations (i.e., Hospitals,Coffee shops or Shopping malls) on the Map. Add a button to your XAML page and on ‘Click’ event handler place below code. using Windows.Devices.Geolocation; private async void btnMapTask_Click(object sender, RoutedEventArgs e) { // Get the Current location Coordinates Geolocator geolocator…


