The new Column comparison in queries in Dynamics 365 / PowerApps

Nishant Rana's Weblog

Column Comparison is one of the best features that has been recently added to the product.

Column comparison allows us to compare values of 2 different columns in our query be it Fetch XML, Web API, or through SDK API.

Sharing some of the basic examples that we tried using our favorite  FetchXML Builder

  • If we run the following query “Find all contact which has the first name equal to the last name”

The result –

  • Find all contact where the first name is not equal to last name

The result –

The operators supported are –

EqualLessEqualGreaterEqual
Not EqualLessThanGreaterThan
  • Only 2 columns can be compared.
  • Only compatible attribute types can be compared.
  • E.g. “Find all contact where the first name is equal to address 1 city”

The result

It works as both are string attributes.

  • If we try comparing text field with options set, we…

View original post 111 more words

Published by amars4u

• Experience in gathering requirement, creation of Functional Design and providing Functional Demo to client. • Experience in Functional Testing, Test Automation, Integration Testing, and Data Migration Testing on various applications in Microsoft Dynamics CRM, Microsoft SharePoint and USD for Dynamics CRM • Hands-On Experience in EasyRepro Automation Framework, Coded UI, Selenium, Microsoft VSTS, VSO, and MTM • Worked on Test Scenario creation, Test case creation, Test data creation, Test Case execution, Defect reporting, Smoke testing, Regression, and Ad-hoc testing in Agile model at SIT environment • In depth knowledge of developing & executing standard test plan & procedure • Have experience in onshore-offshore project model, working with teams from Offshore, Leading the test team and sending status report to senior management and stakeholders • Have experience of leading Functional, Automation and Data Migration Test Team.

Leave a Reply

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

WordPress.com Logo

You are commenting using your WordPress.com 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

%d bloggers like this: