Compare two columns in QueryExpression in Dynamics 365/ CDS SDK

The QueryExpression examples !

Debajit's Dynamic CRM Blog

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

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 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

Author: Nishant Rana

I love working in and sharing everything about Microsoft.NET technology !

Please share your thoughts

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.