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.