Skip to content
Primary Menu
  • Home
  • About
  • Blog
  • Tools
  • Twitter
  • LinkedIn
  • GitHub
Mark Carrington

Data, D365, Diabetes, Lego, …

FetchXML

  • Home
  • MSDyn365
  • FetchXML
Category: FetchXML

New FetchXML Features and Documentation

Posted On 8th March 20248th March 2024 By Mark Carrington7 Comments

Microsoft have recently released a new in-depth set of documentation for FetchXML, and it includes some extra features that haven’t been supported before.

Category: FetchXML/SQL 4 CDS

FetchXML Aggregate Queries, Lookup Fields and Paging

Posted On 13th January 202218th January 2022 By Mark Carrington1 Comment

David Fraticelli raised an interesting bug that became apparent in SQL 4 CDS. Many thanks to David for all his help in tracking down what was happening. I’ve mentioned before the many ways that paging in FetchXML can give rise to unexpected results. One key thing to ensure you get Continue Reading

Category: FetchXML/MSDyn365

Identifying merged records

Posted On 6th October 20216th October 2021 By Mark Carrington1 Comment

You can use duplicate detection rules to find duplicate records in Dynamics 365 (or do it even better with Data8 Duplicare!), but how do you go back and find what records have been merged, or by whom?

Category: FetchXML/SQL 4 CDS

Integrating SQL 4 CDS with your own XrmToolBox tool

Posted On 3rd October 2021 By Mark Carrington2 Comments

One for the XrmToolBox developers: if you want to make use of the power of SQL 4 CDS from your own tool, how can you do it?

Category: FetchXML/MSDyn365/MSDyn365 Internals

MSDyn365 Internals: Paging Gotchas

Posted On 23rd February 202123rd February 2021 By Mark Carrington4 Comments

I’ve recently been looking at a few cases where I’ve got seemingly incorrect results from my FetchXML queries. This can manifest itself as the results limited to 50,000 records or records being skipped. I’ve narrowed these down to some behaviour I wasn’t aware of when you retrieve multiple pages of Continue Reading

Category: FetchXML/MSDyn365/SQL 4 CDS

Dataverse Paging with Distinct

Posted On 8th December 20208th December 2020 By Mark Carrington1 Comment

I hit a strange situation yesterday. I was retrieving data from Dataverse with a FetchXML query but some values were missing from my results, while others were duplicated. Turns out it’s an easy situation to get into without noticing.

Category: FetchXML

FetchXML Late Materialize

Posted On 9th October 20209th October 2020 By Mark Carrington4 Comments

The latest addition to FetchXML is Late Materialize. Turning this on or off doesn’t change the results of your query, but it does change how it’s executed behind the scenes, which could lead to some performance improvements.

Category: FetchXML/MSDyn365

Querying Metadata with FetchXML

Posted On 29th September 202029th September 2020 By Mark Carrington3 Comments

I’ve looked at different ways of accessing CDS metadata recently, but there’s another way I’d overlooked – using FetchXML. CDS exposes a limited amount of metadata as special virtual entities that lets you query it using standard FetchXML syntax:

Category: FetchXML/MSDyn365/SQL 4 CDS/T-SQL

Multi-select Picklist Filtering

Posted On 27th August 202028th September 2020 By Mark Carrington6 Comments

I’ve been doing some work today on filtering multi-select optionset fields in SQL 4 CDS and using the T-SQL endpoint, and I came across a few interesting quirks.

Category: FetchXML/MSDyn365

FetchXML Date Filtering

Posted On 25th August 202028th September 2020 By Mark Carrington39 Comments

One great option in FetchXML is to filter dates using a relative filter such as “this week”, “older than 2 years” etc. This is particularly helpful when you build a view, as it will automatically build the date criteria each time so your view is always up to date.

Posts navigation

1 2 3 Next

Copyright © All rights reserved Theme: Infinity Blog by Themeinwp