CODEWITHSUNDEEP
dynamics-crmcrmfetchxml
Vignesh Subramanian
Vignesh Subramanian

Reputation: 7289

Ignore Casing in dynamics CRM FetchXML

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?

Upvotes: 0

Views: 1615

Answers (1)

Martin
Martin

Reputation: 39

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://learn.microsoft.com/en-us/dynamics365/customer-engagement/on-premises/sql-server-requirements-recommendations

Upvotes: 2

Related Questions