XRMTOOLBOX SQL 4 CDS to get logged in users, Users with security roles in Dynamics 365

Hello Everyone,

Today i am going to show the XRMTOOLBOX tool SQL 4 CDS which allows you to use standard SQL  syntax to query and manipulate your data and metadata in Dataverse and Dynamics 365.

Let’s gets started.
Here is the link for sql 4 cds 

SQL 4 CDS tool Capabilities:
First of all many thanks to creator of this tool Mark Carrington.
As per the release notes:
Add support for XML data type and FOR XML clause.

Add support for Elastic tables

Add support for Stuff function

Add option to bypass plugins for SELECT statements

Improved error reporting for duplicated table/alias names

Improved error reporting for plugin errors

Improved efficiency of joins that can’t be translated to FetchXML

Improved error handling during bulk DML Operations

Fixed querying audit table

Fixed Collation label for metadata and virtual columns

Fixed hash joins on different collations

Fixed filtering on outer-joined solution table

Fixed multi threading error with partitioned aggregations

Fixed copying results with headers but…

Source link

Author: Malla Reddy Gurram

Share This Post On
Share via
Copy link
Powered by Social Snap