Skip to Content

Fiori List report - Case insensitive Filter bar

May 04 at 04:15 PM


avatar image

Hi -

I have Fiori template based List report with XSODATA based oData service and have a filter bar with text filter ( Example - Customer Name).

Problem is filter is case sensitive and does not return results unless the exact text is typed in which is poor user experience.

Is there a way we can make filter bar case insensitive? any trick that may work on xs odata side or any API reference can be used in list report extensions ?

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Ivan Mirisola
May 07 at 10:55 PM

Hi Tanveer,

HANA will issue a EQ statement on the field. So this has to be exact criterion. I couldn't find any xsodata definition parameter that would control/change this EQ to CONTAINS statements against the database source. So you will need to create an extension on the controller for the List Report and implement/change the filter that is being set before the odata service is called via controller method onSearch.

You could do it like:

var oFilter = new Filter("CustomerName", FilterOperator.Contains, sQuery);

Here are the docs for the Filter.

Another workaround is to change the query string to uppercase before it gets to be sent as query string to the odata.


10 |10000 characters needed characters left characters exceeded