Is $filter eq case sensitive or not?

David Wong 46 Reputation points
2023-05-02T07:20:33.84+00:00

I expect 'eq' in $filter is case sensitive, i.e. searching for $filter="displayName='John'" will not match ‘john’. People had asked how to do case insensitive search such as:

However, as I tested recently. It is case insensitive. My case is filter user records in Azure AD B2C. Is there any official document about this?

Microsoft Graph
Microsoft Graph
A Microsoft programmability model that exposes REST APIs and client libraries to access data on Microsoft 365 services.
11,124 questions
0 comments No comments
{count} vote

2 answers

Sort by: Most helpful
  1. TH-4749-MSFT 3,295 Reputation points
    2023-05-03T19:26:53.2166667+00:00

    Hi David Wong,

    Thanks for reaching out. According to OData documentation :

    OData Protocol V4.01 based services support case-insensitive system query option names specified with or without the $ prefix.

    This applies to Microsoft Graph.

    Thanks.


  2. TH-4749-MSFT 3,295 Reputation points
    2023-05-29T17:07:00.59+00:00

    Hi David Wong,

    Hope all is well. If the previous reply was helpful, please click Accept Answer and kindly upvote it. If you have additional questions about this answer, please click Comment.

    Thanks.

    0 comments No comments