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

Data, D365, Diabetes, Lego, …

SQL 4 CDS

  • Home
  • MSDyn365
  • SQL 4 CDS
  • Page 3
Category: SQL 4 CDS

SQL 4 CDS 3.0.0 Released

Posted On 2nd November 20202nd November 2020 By Mark Carrington6 Comments

I’m pleased to announce that I’ve just released version 3 of SQL 4 CDS. The main updates in this release are: Metadata queries Support for virtual (___name) attributes

Category: MSDyn365/SQL 4 CDS

SQL 4 CDS 2.3.0 Released!

Posted On 1st September 202028th September 2020 By Mark Carringtoncomment

I’m pleased to release the latest update for SQL 4 CDS today! For this update I’ve focused on common problems I’ve seen people encounter with their queries from my telemetry. These updates should either mean that more queries can be executed immediately, or the error message is more descriptive to Continue Reading

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

Multi-select Picklist Filtering

Posted On 27th August 202028th September 2020 By Mark Carrington2 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: MSDyn365/SQL 4 CDS

SQL 4 CDS 2.2.0 released

Posted On 15th July 202028th September 2020 By Mark Carringtoncomment

I’m pleased to release SQL 4 CDS 2.2.0 with two main improvements:

Category: MSDyn365/SQL 4 CDS/T-SQL

SQL 4 CDS 2.1.0 – the T-SQL edition

Posted On 24th May 202028th September 2020 By Mark Carrington5 Comments

Since I’ve been doing some investigation into the new preview T-SQL endpoint for CDS recently, I’ve decided to integrate it into SQL 4 CDS. Update to 2.1.0 to get:

Category: MSDyn365/SQL 4 CDS

SQL 4 CDS 2.0.0 released!

Posted On 17th April 202028th September 2020 By Mark Carrington4 Comments

I’m very pleased to release version 2.0.0 of my SQL 4 CDS tool today! If you haven’t come across it before, SQL 4 CDS is an XrmToolBox tool to query and manipulate your CDS data using regular SQL queries, making it accessible to a much wider range of users. You Continue Reading

Category: MSDyn365/SQL 4 CDS

SQL 4 CDS 1.0.9 Released!

Posted On 3rd February 202028th September 2020 By Mark Carrington2 Comments

I’ve just released SQL 4 CDS 1.0.9. Please update it when XrmToolBox prompts you to take advantage of these latest features:

Category: MSDyn365/SQL 4 CDS

SQL 4 CDS 1.0.6 Released!

Posted On 10th January 202028th September 2020 By Mark Carrington23 Comments

I’m very pleased to announce the release of SQL 4 CDS version 1.0.6! Please update your existing versions in XrmToolBox to get some great new features…

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

Posts navigation

Previous 1 2 3

Copyright © All rights reserved Theme: Infinity Blog by Themeinwp