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
Hope it helps..
One thought on “How to – Convert Fetch XML to SQL in Dynamics 365”