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

Data, D365, Diabetes, Lego, …

SQL 4 CDS v9.6 released

Lots of new possibilities for working with your Dataverse data with this latest update! (more…)

Read More

SQL 4 CDS v9.5 Released

Updates to SSMS compatibility, bulk operations, optionset metadata access & more... (more…)

Read More

SQL 4 CDS v9.4 Released

I was reviewing some incredible usage stats for SQL 4 CDS recently which showed that UPDATE statements make up almost

Read More
Category: FetchXML/MSDyn365

Inside FetchXML pt 3 – filter

Posted On 3rd December 201928th September 2020 By Mark Carrington35 Comments

So far we’ve looked at using the <attribute> and <link-entity> elements to control what columns to include in your query, but for a truly useful query you’ll likely want to select which rows to include instead of taking everything. Enter <filter>!

Category: FetchXML/MSDyn365

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.

Category: FetchXML/MSDyn365

Inside FetchXML pt 1 – attribute

Posted On 19th November 201928th September 2020 By Mark Carrington4 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.

Category: MSDyn365/SQL 4 CDS

SQL 4 CDS Update!

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

Firstly, thank you to everyone who’s shown an interest in my SQL 4 CDS XrmToolBox tool! I’ve been busy working on the difficult second release, and I’m pleased to announce version 1.0.3 is in the new Tool Library today!

Category: MSDyn365/SQL 4 CDS

Query CDS with SQL!

Posted On 16th October 201928th September 2020 By Mark Carrington12 Comments

If you’re anything like me you probably find querying the data in CDS a pain, either using the Advanced Find interface or writing FetchXml. Tools such as FetchXMLBuilder help a lot, but I still think about the query I want to write in good-old SQL and then have to translate Continue Reading

Category: MSDyn365/MSDyn365 Internals

MSDyn365 Internals: Merge Permissions

Posted On 31st August 201912th October 2021 By Mark Carrington19 Comments

The ability to merge records is a powerful one in keeping control of your data quality within PowerApps / D365. It can also be deceptively complex. As we’ve been living & breathing this area of the platform for several years during the development of data8 duplicare, we’ve seen a lot Continue Reading

Category: MSDyn365/MSDyn365 Internals

MSDyn365 Internals: Plugin Execution Depth and v9

Posted On 29th May 201928th September 2020 By Mark Carringtoncomment

If you’ve been working with plugins in Microsoft Dynamics 365 for a while, you’ve probably come across the IExecutionContext.Depth property. This tells your plugin how deep in a call stack of plugins it is. A depth of 1 means it is being triggered by a direct user action, e.g. updating Continue Reading

Category: Azure/Diabetes/MSDyn365

Blood Glucose Alerts with Microsoft Flow and Nightscout

Posted On 8th April 201928th September 2020 By Mark Carringtoncomment

As my son has Type 1 Diabetes (T1D), we use Nightscout to keep track of his blood glucose levels. With T1D it’s important to keep those levels in quite a tight range, so we use a few different apps to alert us when it’s going out of range. As I’ve Continue Reading

Category: MSDyn365/MSDyn365 Internals

MSDyn365 Internals: QualifyLead

Posted On 27th March 201928th September 2020 By Mark Carrington1 Comment

One thing I love digging into with Microsoft Dynamics 365 is all the “special” actions. Although just about any entity type can be used with Create, Update, Retrieve etc., there are a lot of other actions that do more specialised jobs, and QualifyLead is a great one of these.

Category: MSDyn365

Handling RetrieveMultiple Paging

Posted On 20th March 201928th September 2020 By Mark Carrington3 Comments

When you use the RetrieveMultiple method to query data from D365 CE, it’s easy to take the results and assume that’s everything, especially when you’re working with small test data sets.

Posts pagination

Previous 1 … 12 13 14 Next

Copyright © All rights reserved Theme: Infinity Blog by Themeinwp