Compare two columns in QueryExpression in Dynamics 365/ CDS SDK

Sending
User Review
0 (0 votes)

The QueryExpression examples !

All about Dynamics 365, PowerApps, Power Platform and Power Apps portals by Debajit Dutta

Follow my blog for more interesting topics on Dynamics 365, Portals and Power Platform. For training and consulting, write to us at info@xrmforyou.com

A long awaited feature which has been asked by customers for over a decade has been finally introduced in the platform. And today I referred a blog post by my friend and fellow MVP Nishant Rana on how you can compare two columns in fetchxml.

In this blog article I am going to discuss on how we can compare two columns in QueryExpression.

To use the SDK API in your custom code make sure you install the latest SDK assemblies from Nuget. I have installed latest version 9.0.2.26 of Microsoft.CrmSdk.CoreAssemblies in my project. Prepare a query expression to filter the necessary set of records from any entity. Here I am retrieving data from contact. You can see below is the new construct available to compare two attributes

View original post 221 more words