Kendo Grid Filtering at client Side Issue

[Sunny]

Hi,
Below is my code,

 var _fltMain = { logic: "or", filters: [] };
 var _fltRegion = { logic: "or", filters: [] };
 _fltRegion.filters.push({ field: "Region", operator: "contains", value: searchText });
  var _fltOAMOrders = { logic: "or", filters: [] };
 _fltOAMOrders.filters.push({ field: "OAMOrders", operator: "contains", value: searchText });
 
_fltMain.filters.push(_fltRegion);
 _fltMain.filters.push(_fltOAMOrders);

 $("#reportGrid").data("kendoGrid").dataSource.query({ filter: _fltMain });

This Code works fine for first filter but not working for fltOAMOrders this filter.
It gives error
Microsoft JScript runtime error: Object doesn't support this property or method
((d.OAMOrders || '').toLowerCase().indexOf('56') >= 0)
because it is of type decimal.

Please help.

Thanks,
Sunny.

[Brian]

I am having a similar issue with trying to filter my grid client side when the json result for the column is a decimal.

[Paul]

Has this been solved yet? I am experiencing this problem with filtering a datasource on an integer field.

[Nikolay Rusev]

Hello,

It is expected have the error in the described scenario. When you sing filter expressions there are two thing that you must validate before applying it to the DataSource:
 - the operator is valid, i.e has meaning for the target type. It doesn't make sense of using `contains` for `numeric` types.
 - the value of the expressions is converted to the target type, i.e `searchText` must be number / parseInt(searchText, 10) / 

Regards,
Nikolay Rusev
Telerik