You searched for Fetch XML Builder - Page 3 of 3

SQL 4 CDS Additional Processing

Posted On 22nd March 202022nd March 2020 By Mark Carrington

SQL 4 CDS attempts to convert your SQL query into FetchXML so it can be executed natively by CDS. However, SQL is a very rich language and there are a lot of queries that can’t be directly converted. For example, trying to compare two fields: There is no way to Continue Reading

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…

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!

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

SQL 4 CDS XrmToolBox Tool

Posted On 9th October 201929th November 2021 By Mark Carrington

Know SQL and want to access your Dataverse/CDS/PowerApps/D365 data? Enter SQL 4 CDS, my XrmToolBox plugin to get a SQL Server Management Studio type interface to query your data! If you’re using SSMS to connect to the TDS endpoint you can also check out the SSMS edition! Introduction Installation Connecting Continue Reading