Upload a Fetch XML query to CRM 2016

(0) Share

Report

Posted on by Community Member

I've written a Fetch XML query and I now want to import it into the Advanced Find View as a Saved query and see the results. How do you do this ? thank you.

*This post is locked for comments

I have the same question (0)

All responses (10)

Answers (0)

Community Member on at

Like (0)

Report

From looking into this , it looks like I have to import the Fetchxml as part of a solution. I've already exported the Default customizations.xml. Is it possible just to import Fetchxml query and not the entire customizations.xml into CRM ?

Was this reply helpful? Yes No
ashende on at

Like (0)

Report

If you are using CRM 2016, create a solution that includes only the system view with the same columns as your fetchxml as a starting point, export the solution, extract customization.xml from the zip file, replace the original fetchxml with your fetchxml, add customization.xml back in the zip file, then import it.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Create new view programmatically msdn.microsoft.com/.../gg594431.aspx

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

This looks good, but how does one put the C# code into the CRM application ?

Was this reply helpful? Yes No
Suggested answer

Luke Sartain 1,266 on at

Like (1)

Report

Unless you're a developer I'd forget about trying to programmatically create views. Instead it may be worth you using the View Designer within XrmToolBox. Although you cannot create a view from scratch you can create a new view within CRM (only needs to consist of 1 column for your chosen entity), open it in View Designer, Click Edit XML and then paste in what you've got, overwriting that single column. Also a lot less tedious that amending the XML from an exported solution or writing C#.

www.xrmtoolbox.com/download.html

Was this reply helpful? Yes No
Saroj Das 3,355 on at

Like (0)

Report

Create a console application and add your fetch xml. It will create your view. Uriy has already given the link. Please refer that.

Thanks,

Saroj

Was this reply helpful? Yes No
Suggested answer

Arun Vinoth 11,615 Moderator on at

Like (0)

Report

No code solution. Use this trick to construct Advanced find query from a fetchxml: www.linkedin.com/.../generate-fetchxml-condition-crm-advanced-find-using-query-kumar

Then you can save as personal view or recreate as a system view.

Was this reply helpful? Yes No
Suresh Kumar VC 10 on at

Like (1)

Report

Thanks for this direction.

Was this reply helpful? Yes No
Suggested answer

CRMJetty 3,512 on at

Like (0)

Report

Hello,

pls review this article,

https://www.crmjetty.com/blog/how-to-create-and-save-fetchxmlquery-from-dynamics-365/

Was this reply helpful? Yes No
Suggested answer

CRMJetty 3,512 on at

Like (0)

Report

Hello,

pls review this article,

https://www.crmjetty.com/blog/how-to-create-and-save-fetchxmlquery-from-dynamics-365/

I hope it helps,

Thanks.

Please mark as verified if the answer is helpful. Welcome to join hot discussions in Dynamics 365

Was this reply helpful? Yes No