FetchXML Aggregate Queries, Lookup Fields and Paging
In this post, Mark Carrington discusses an interesting bug that was found in SQL 4 CDS by David Fraticelli, which sheds light on how FetchXML aggregate queries, lookup fields, and paging can interact in unexpected ways. The author highlights some of the potential risks and pitfalls that come with FetchXML queries, particularly when it comes to pagination. He emphasizes the need for careful attention and thorough testing to ensure that your queries are behaving as intended and that you're not inadvertently introducing errors into your data.
While the post delves into some technical details, it will be worth reading for any developer or data analyst who is working with FetchXML queries in Power Platform or CDS. The insights and tips shared can help you avoid common pitfalls and ensure that your queries are delivering accurate and reliable results.
The post FetchXML Aggregate Queries, Lookup Fields and Paging was originally published on Mark Carrington.
Published on:
Learn moreWe can help you with FetchXML Aggregate Queries, Lookup Fields and Paging
If you want help implementing, troubleshooting, or improving this product, contact us and we’ll point you in the right direction.
Related posts
SQL 4 CDS 5.4 Released
The latest release of SQL 4 CDS, version 5.4, offers improved aggregate query performance and now includes .NET Core compatibility for develop...
How to get direct count using Fetch XML capabilities
Explore the powerful capabilities of FetchXML in Dynamics 365 with this informative post. As a query language, FetchXML retrieves data from th...
SQL 4 CDS v7.3 Released
A new update for SQL 4 CDS has been released, bringing with it support for exciting new features such as the Elastic Tables feature and XML da...
SQL 4 CDS 5.3 Released
A new SQL 4 CDS version, 5.3, has been released by Mark Carrington. This version includes cross-instance queries which enable joins between Da...
DYNAMICS 365 HOW TO EXECUTE FETCHXML QUERIES IN WEB.API JAVASCRIPT
If you're working with Dynamics 365 and require retrieving data through WebAPI calls, FetchXml might be the best option for more complex queri...
Use of aggregate, groupby in fetchxml query
This post dives into the use of aggregate and groupby functions in FetchXML queries. By utilizing these functions, users can create more compl...
SQL 4 CDS 6.4 Released
A new update of SQL 4 CDS has been released and it includes a support for early versions of CRM and more complex queries. Besides, the release...
SQL 4 CDS v8 Released
SQL for CDS v8 brings with it a game-changing feature – Common Table Expression (CTE) support, along with enhanced JSON functionality. ...
SQL 4 CDS 6.3 Released
The latest release of SQL 4 CDS (v6.3) brings useful enhancements and fixes to the table. The update includes performance improvements for INS...