Community
Showing results for 
Search instead for 
Do you mean 
Reply

odata filter case sensitive?!?

Copper Contributor
Posts: 189
Country: Netherlands

odata filter case sensitive?!?

I just found out that the OData filter on the Act! Web API (v1.0.449.0) is case sensitive. 

 

I have a contact 'Piet van der Test' in the database, and it doesn't make it to the results when:

 

/api/contacts?$filter=contains(fullname, 'Test')

 

but it does when:

 

api/contacts?$filter=contains(fullname, ‘test')

 

This should never be the case, people won't expect this and get confused.

Greetings,

ACT Certified Consultants
TendenZ
the Netherlands
Copper Contributor
Posts: 189
Country: Netherlands

Re: odata filter case sensitive?!?

In addition to that, we have an API 1.0.317.0, where it isn't case-sensitive. So it's a bug which is introduced in a later stadium.

Greetings,

ACT Certified Consultants
TendenZ
the Netherlands