Nishant Rana

How to – Convert Fetch XML to SQL in Dynamics 365

Hi,

Recently we had a requirement to convert Fetch XML query of certain views to SQL. Basically, we wanted to validate it again the source DB from which we push the data inside Dynamics 365.

For this we can use the below managed solution,

https://fetchxml2sql.codeplex.com/

The tool is built using Silverlight so will only work in IE.

The other tool is that we can use is one of the most useful plugins – Fetch XML Builder of XRM Tool Box.

Below video explains how to use them

https://www.youtube.com/watch?v=OESJxa3bwrU

And in case you’d feel like converting fetch xml to SQL we have

http://www.sql2fetchxml.com/

Hope it helps..

Annual Report – 2017 in Blogging– “Nishant Rana’s Weblog”

As there will be no Year in Review Annual Report for the WordPress blog, I have created the report myself, following the same pattern used by WordPress.

The blog was viewed about 303,182 times in 2017 with 186,110 visitors: –

Below were the top posts in 2017: –

Below were the top referrers: –

‘

All time views: –

Index (zero based) must be greater than or equal to zero and less than the size of the argument list

Nice solution 🙂

Prashant Kumar Maurya

Hello friends, I found a weird issue during a USD configuration, I was getting error message “Index (zero based) must be greater than or equal to zero and less than the size of the argument list“, when I was trying to assign a custom entity record to a different agent (systemuser) using USD action call.

Scenario: A CRM custom entity record get created in Unified Service Desk when an agent receives a customer call. And if agent transfer customer call to their supervisor, same entity record should also get assigned to supervisor. Below are the details of the action call I created.

Issue: action call was failing with error message “Index (zero based) must be greater than or equal to zero and less than the size of the argument list“, complete error message was

======================================================================

Action Call# 20

Source:Window Route(CTI Window Navigation Rule – Transfer Call)

View original post 118 more words

Packt’s $5 sale is now on! Grab my @packtpub book Dynamics 365 Application Development for just $5 https://www.packtpub.com/application-development/dynamics-365-application-development

Packt’s $5 sale is now on! Grab my @packtpub book Dynamics 365 Application Development for just $5 https://www.packtpub.com/application-development/dynamics-365-application-development.

Unified Service Desk Issue #1: Save Event does not trigger for CRM Page hosted control.

Helpful article helped us fixed an issue on USD 3.0

Prashant Kumar Maurya

Hello friends, recently I migrated my configurations from USD 2 to USD3. After successful migration I added one action call to scan for data parameters on save event oh hosted control. I created few new hosted control of same type and there save even was working as expected.

Issue: save event was not triggering for CRM Page type hosted control.

Reason: after scratching my head around this issue for i long i thought of comparing this hosted control with other hosted control when save even was working. I create a advance find and added all fields of hosted control entity and added filter to only display details of these 2 hosted controld

One CRM hosted control for which save event was working fine.
Other CEM hosted control for which save event was not triggering.

Advance Find

When i was comparing the fields values for both hosted control I found one difference in…

View original post 80 more words

Plugin on AddListMembers message. When does it fire?

In one of our recent implementations involving marketing list entity, we were analysing the AddListMembers message for it.

We registered a plugin on AddListMembers message and below were our findings.

Dynamics Marketing List – The plugin didn’t trigger.
Static Marketing List – The plugin didn’t trigger for “Add using Lookup“. It only triggered for “Add using Advanced Find” when “Add only the selected members to the marketing list” option was selected. It didn’t trigger for “Add all the members returned by the search to the marketing list“