Is $filter eq case sensitive or not?

Question

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:

• Is it possible to do case-insensitive search with filter ? (microsoft.com)
• https://stackoverflow.com/questions/65235176/filter-query-for-graph-b2c-for-mixed-case-issuerassignedid

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?

Answer 1

Looking into ODATA specs: https://docs.oasis-open.org/odata/odata/v4.01/odata-v4.01-part2-url-conventions.html#sec_Equals

Equals operators says values must be equal, which suggests case-sensitive comparison

Functions like startswith explicitly specify comparison as case sensitive, and also mention that case-insensitivity shall be achieved via toupper() and tolower() functions

I have good experience with toupper()

hope this helps

Answer 2

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.

Answer 3

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.