sap mdk case sensitive search in Object table search

[sk_ramkumar]

Hi Experts,

Object table search is not case sensitive in my application, we can only enable the search in object table, as we don't have any other event to control that, I am wondering the case sensitive search is working in mentor app but not in my application. 

I have an online application ( offline is not enabled ) , using 24.4.1 latest iOS client. Is something we need to do in oData level for tolower() as mentioned in this thread ? 

https://community.sap.com/t5/technology-q-a/sap-mdk-control-type-formcell-sorter-sorts-by-case-sensi...

@bill_froelich @Jitendra_Kansal 

Thanks in advance,

Ram

[Jitendra_Kansal]

@sk_ramkumar Can you clarify if search in Object Table is case sensitive or case insensitive in your MDK application?

[bill_froelich · Accepted solution]

First you should verify if your backend OData service supports tolower() and substringof() if a V2 service or tolower() and contains() for v4.  For an Online MDK connection we do not include tolower() in the search term by default since not all backends have implemented this function.

If your backend supports it can write a rule for your Object Table Target Query Options to customize the search string to include tolower to force the case insensitive search.

[sk_ramkumar · Accepted solution]

Thank you @bill_froelich I managed to add rule in Query Options and send tolower and toupper method to backend.