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
SQL 4 CDS 2.3.0 Released!
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
Multi-select Picklist Filtering
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.
SQL 4 CDS 2.2.0 released
I’m pleased to release SQL 4 CDS 2.2.0 with two main improvements:
SQL 4 CDS 2.1.0 – the T-SQL edition
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:
SQL 4 CDS 2.0.0 released!
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
SQL 4 CDS 1.0.9 Released!
I’ve just released SQL 4 CDS 1.0.9. Please update it when XrmToolBox prompts you to take advantage of these latest features:
SQL 4 CDS 1.0.6 Released!
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…
SQL 4 CDS Update!
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!
Query CDS with SQL!
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