OData casesensitive issue

Asked Sep 26 '19 at 14:03

Active Sep 29 '19 at 05:16

Viewed 67 times

Facing one issue while doing lambda query using OData. For example below are the query which I am doing:

Value that is stored in Database is Hubbardston

Scenario 1:

http://localhost:32339/Enquiry?$filter=relatedParty/any(r: r/religion eq 'Hubbardston')

Result: working fine

Scenario 2:

http://localhost:32339/Enquiry?$filter=relatedParty/any(r: r/religion eq 'hubbardston')

Result: Not working

So basically it is behaving like case sensitive, how can we make it case insensitive?

edited Sep 26 '19 at 14:57

James Z

asked Sep 26 '19 at 14:03

Avinash Kumar

When you say `Not working`, does it mean you are not getting any result? – Chetan Sep 26 '19 at 14:07
Probably duplicated: https://stackoverflow.com/questions/13495905/odata-query-filter-conditions-and-case-sensitivity – Oleg Sep 26 '19 at 14:07
@ChetanRanpariya it is returning with blank object in scenario 2 – Avinash Kumar Sep 26 '19 at 14:20
1

@Oleg If it is not lambda query then we can apply tolower but here we can not apply, So I need resolution in case of lambda query – Avinash Kumar Sep 26 '19 at 14:21
Can you try apply tolower('Value') – Oleg Sep 26 '19 at 14:48
@Oleg No tolower is not working in my case. – Avinash Kumar Sep 27 '19 at 07:34
What is the version of odata? – Oleg Sep 27 '19 at 07:41
@Oleg it is 7.2.1.30805 – Avinash Kumar Sep 27 '19 at 11:11
it's yours server side and can you get the details? – Oleg Sep 29 '19 at 05:16

0 Answers0