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

Data, D365, Diabetes, Lego, …

Search Results for: Fetch XML Builder

  • Home
  • Search results for: Fetch XML Builder

FetchXML Builder Updates

Posted On 9th December 201928th September 2020 By Mark Carringtoncomment

I’m very proud to have some more of my contributions included in the latest release of the popular FetchXML Builder tool!

FetchXML Builder WebAPI Support

Posted On 12th March 201928th September 2020 By Mark Carringtoncomment

MSDyn365 MVP Jonas Rapp threw down a challenge on Twitter last week: True, I’ve been ignoring for too long…If you know some C# and some #MSDyn365 WebAPI queries – please help…! 😊Pull Requests accepted! https://t.co/7iHp6XzQbf — Jonas Rapp ᴹᴠᴾ 🇸🇪 (@rappen) March 4, 2019

Querying Metadata with FetchXML

Posted On 29th September 202029th September 2020 By Mark Carrington2 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:

Column Comparisons in FetchXML

Posted On 15th July 202028th September 2020 By Mark Carrington10 Comments

I was very pleased today to see a new feature in FetchXML – column comparisons! This allows us to build queries that compares the values in one column against those in another. Previously we’ve only been able to compare a column against a constant value.

Inside FetchXML pt 10 – link-entity (again)

Posted On 5th April 202028th September 2020 By Mark Carringtoncomment

A follow-up on my previous post on link-entity, prompted by this tweet from Daryl LaBar: Was unaware of the new join operators. @jordimontana @XrmWizard have either of you used these, or know what they are supposed to do? The documentation is rather lacking…https://t.co/Nr4AyZMzb2 — Daryl LaBar (@ddlabar) April 2, 2020

FetchXML Multiple Links

Posted On 13th January 202028th September 2020 By Mark Carringtoncomment

One common pattern of queries I see about FetchXML is how to write queries to ask two different questions about the same related entity. For example: Invoices that include product A AND product B? Contacts that have pending emails AND no sent emails? Visits that have a page view of Continue Reading

Inside FetchXML pt 2 – link-entity

Posted On 25th November 201928th September 2020 By Mark Carrington1 Comment

To combine data from different records in your query you need to use the <link-entity> element. This is equivalent to a join in SQL.

Inside FetchXML pt 1 – attribute

Posted On 19th November 201928th September 2020 By Mark Carrington3 Comments

As promised, I’m starting a series of blog posts covering various aspects of FetchXML and the humble <attribute> element seems like a good place to start.

SQL 4 CDS 6.3 Released

Posted On 29th June 202229th June 2022 By Mark Carrington2 Comments

I’ve just released SQL 4 CDS v6.3 with a number of useful improvements and fixes.

SQL 4 CDS v6 Released

Posted On 11th April 202211th April 2022 By Mark Carrington15 Comments

It’s time for another big update to SQL 4 CDS – this one’s been in the works for 3 months and has got some great improvements to its level of SQL support, performance, integration with SSMS and reusability in custom apps. New SQL support: Variables You can now declare and Continue Reading

Posts navigation

1 2 3 Next

Copyright © All rights reserved Theme: Infinity Blog by Themeinwp