Ignore Casing in dynamics CRM FetchXML

0
votes

I am using the below FetchXML

 <filter type="and">
      <condition attribute="emailaddress" operator="eq" value="[email protected]" />
    </filter>

So is there a way to ignore casing in Fetch XML?

1
dynamics-crmcrmfetchxml
stackoverflow.com/a/10988415/7920473 - Arun Vinoth - MVP
Thanks @ArunVinoth I am looking for doing it with FetchXML - Vignesh Subramanian
if you would have read the answer you can understand it’s more of a SQL settings - Arun Vinoth - MVP
As far as I know, D365 defaults to a case insensitive collation for North American orgs using American English. What region are you in? Have you found an example where the casing of a value in D365 caused you to get different results than you wanted? - Aron
Possible duplicate of Case insensitive QueryExpression - Zach Mast

1 Answers

2
votes

It depends on sql server Database Settings. Default is case insensitive.

Although it’s optional, consider accepting the SQL Server default settings for Collation Designator, Sort Order, and SQL Collation. Dynamics 365 for Customer Engagement supports the following collation orders:

  • Case-sensitive
  • Case-insensitive
  • Accent-sensitive
  • Accent-insensitive
  • Binary sort order (such as Latin1_General_100_BIN)

https://docs.microsoft.com/en-us/dynamics365/customer-engagement/on-premises/sql-server-requirements-recommendations