Dataverse: How to set a Complex Query for System View
This guide explains how to set up complex queries for system views using XrmToolBox plugins within Microsoft Dynamics CRM. The process begins with preparing XML using SQL4CDS by Mark Carrington to generate an SQL query that can be converted into FetchXML. The FetchXML must comprise a single-step query to be effective, and the guide details how to merge this XML with existing XML for system views. Using the View Designer and FetchXML Builder tools, you can edit and configure views, merging fetched XML data seamlessly. It outlines how to publish the merged view, optimize column settings, and test the setup via Model Driven Apps. By customizing views this way, users can access relevant records based on dynamic relationships, enhancing CRM's functionality and user experience.
Article 3w
Login now to access my digest by 365.Training
Learn how my digest works
Features
- Articles, blogs, podcasts, training, and videos
- Quick read TL;DRs for each item
- Advanced filtering to prioritize what you care about
- Quick views to isolate what you are looking for right now
- Save your favorite items
- Share your favorites
- Snooze items you want to revisit when you have more time