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?

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.

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.

Is $filter eq case sensitive or not?

David Wong 46

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?

2 answers

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.
Please sign in to rate this answer.
David Wong 46 Reputation points

2023-05-03T20:06:29.0033333+00:00

Hi TH-4749,

I am sorry, I am new to OData. I checked the 4.01 document; my understanding is system query option refers to $select or $filter. So, instead of ‘$select’, I can use ‘select’ or ‘$Select’; I tested, and indeed, this is the case.

However, my question is about the result of the query. For example, say I have two user records in B2C with displayName ‘David’ and ‘david’. I get two records back if I use” $filter=DisplayName eq ‘dAvid’”.

Romano, Andrea 0 Reputation points

2023-12-15T11:27:13.8566667+00:00

Hi, I have the same question about "eq" operator. If I use $filter=(customer/tenantId eq 'a84c5b76-83f0-4d33-b4e9-7ac6853b6dc7') or I use $filter=(customer/tenantId eq 'A84C5B76-83F0-4D33-B4E9-7AC6853B6DC7') it is different.

In the second filter I haven't the corrected result, why?
Sign in to comment
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.
Please sign in to rate this answer.

0 comments No comments
Sign in to comment

Share via

Is $filter eq case sensitive or not?

2 answers