Hi,
I am using Ken-do Grid in my web application using ASP.Net. I have string, date and number type columns. I am able to filter or search on each individual column including date fields working fine. But i have requirement like user should able to search in all the columns at a time. Means need to provide a text box to enter some text, based on this text need to search on all the columns. User can enter full value or part of it. For date fields.. user can enter 13/10, here we need to search all the columns which are having 13/10 including date fields and display the rows. I have used column filters for this. That is working fine for only string fields not working for date and number fields. I have date fields also in my grid. But i am unable to search or filter on date and number fields. If i would have date fields in the filters group i am getting " 0x800a01b6 - JavaScript runtime error: Object doesn't support property or method 'toLowerCase' ". I have found issue like "We are entering some part of date as a string in the text box. It cannot be converting as a date type" as of my knowledge. So how can i achieve external filtering on date fields in kendo grid. Do we have any other alternate to this. Please provide me the solution. Following is the code snippet for filtering which i am using:
{
field: "Account", ---> It is a string type. Working fine.
operator: "contains",
value: val ---> search value
},
{
field: "Due", ---> it is a date field which is not working
operator: "contains",
value: val ---> Search value
},