Filtering causes "Uncaught TypeError: Object xxx has no method 'toLowerCase'"

Hello Roland,

This error is raised when you attempt to filter numeric value as a string. For example executing the following script in browser console will result is the same error:

In order to avoid that you must define DataSource schema and describe that those fields are numeric. For example see the DataSource.schema.model definition in this demo: http://demos.kendoui.com/web/grid/local-data.html

This article explains in details the data source configuration: http://docs.kendoui.com/api/framework/datasource#schemamodel-objectkendodatamodel

Regards,
Nikolay Rusev
the Telerik team

I am having this same error. I have specified "number" on my field as defined.
I have attached a testing page for your review.

Hello Craig,

You are observing same error for same reasons. Filtering on numbers as strings is not allowed.
The default filter for the AutoComplete widget is "startsWith". If you still need auto complete in filter menu for that column you should configured it properly.

Here is an example of possible configuration that will work:


Regards,
Nikolay Rusev
the Telerik team

Ok that makes sense.
I was trying to follow the example from:
http://demos.kendoui.com/web/grid/filter-menu-customization.html

It didn't even occur to me that the DropDownList had a default filter applied. I guess I was "assuming" too much. Thanks for the very clear answer to the problem. I hope your answer will be able to assist many other people. I have seen very similar questions about this on StackOverFlow.

Thanks again I will spread the knowledge!

It should be also worth noting that if you are using MVC extensions. You can accomplish the same thing by either changing your number to a string in the schema as follows: 
or more logically use Number function if your javascript is returning a string. 

This was pretty annoying for me to figure out but now all is groovy!

My filter looks like this:

{
  "logic": "and",
  "filters": [
    {
      "field": "iDealNumber",
      "operator": "eq",
      "value": 307304
    },
{
      "field": "dtTradeTime",
      "operator": "gt",
      "value": "2015-03-29T00:00:00.000Z"
    }
  ]
}

And I get: Uncaught TypeError: undefined is not a function

However this works:

{
  "logic": "and",
  "filters": [
    {
      "field": "iDealNumber",
      "operator": "eq",
      "value": 307304
    },
  ]
}

So I suspect it has something to do with the date being a value.

Not sure how to handle it, any ideas?

Hello Darren,

 

I'm not completely sure for your scenario. However based on the information I assume that the `dtTradeTime` is defined as Date in the DataSource. In this case the value for the filter expression should match the type of the field.

 

Regards,
Nikolay Rusev
Telerik