Skip to main content

Notifications

Announcements

No record found.

Dynamics 365 general forum

Ignore casing in Fetch XML query

Posted on by 345

I am using the below fetch XML

 <filter type="and">
      <condition attribute="emailaddress" operator="eq" value="jon@gmail.com" />
    </filter>



So is there a way to ignore casing?
  • Suggested answer
    RaviKashyap Profile Picture
    RaviKashyap 55,410 on at
    RE: Ignore casing in Fetch XML query

    Hi Vicky,

    By default the casing is ignored i.e. both the below filter criteria will return you the same result-

    <filter type="and">

         <condition attribute="emailaddress" operator="eq" value="jon@gmail.com" />

       </filter>

    <filter type="and">

         <condition attribute="emailaddress" operator="eq" value="JON@gmail.com" />

       </filter>

    Hope this helps.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Coming on 11/8!

In our never-ending quest to help the Dynamics 365 Community members get answers faster …

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans