Hi!

I'm getting an error when I try to use the filter row to filter a string value: (d.Status || "").toLowerCase is not a function

Grid:

Lines 23 and 24 both produces same error.

Function:

At runtime, when I try to filter, I get the error. How do I resolve this?

Hеllo Hassan,

Thank you for the provided code configuration!

I have examined it and would propose to define a schema.model for the grid fields. This gives you the following advantages:

1. You could set the date format of the date columns instead of using column templates. See the approach demonstrated in the following Demo:

• https://demos.telerik.com/kendo-ui/grid/remote-data-binding

2. For the Foreign key that you are using (field "Status"), you could add column.value property. This way you will have a DropDown filter out-of-the-box. The approach is demonstrated here:

• https://demos.telerik.com/kendo-ui/grid/foreignkeycolumn

If further questions should arise, do feel free to ask.

Kind Regards,
Silviya Stoyanova
Progress Telerik

Hi! Here is my API controller:

And the model itself is:

I have defined the schema but its not the model but the return type of the API call.

How do I do this?

Also,

Adding this bit: 

under line #11 above in the grid makes it so the grid displays no results. The data is received in proper JSON format.

Update:

Also, adding just this instead still fails:

Hello, Hassan,

My name is Alex and I am covering for my colleague Silviya in her absence.

It appears that the response does not match the schema. In the schema, as it is defined, we are expecting to receive a response with this structure:

{ 
     "result": [{"ParkingCardId":1, "StaffNo": "SomeString", ....}],
     "total": 1
}

In reality, it might be that the response is as follows:

{ 
     [{"ParkingCardId":1, "StaffNo": "SomeString", ....}],
     "total": 1
}

If I am correct, what you should do is:

return Json(new { result = result, total = result.Count }, JsonRequestBehavior.AllowGet);

Finally, it appears that you require a speedier response than the forums can provide. The jQuery premium forums currently  have a response of up to 48 hours during the work week (Mon to Fri) as opposed to up to 24 hours for a private support thread (Mon to Fri). Furthermore, while the Kendo UI team strives to respond to all licensed forum posters in time, the support tickets always take precedence and are part of the licensed support plans:

https://www.telerik.com/purchase/support-plans

While the forums may offer another perspective from other Kendo UI Developers, the fastest way to get a guaranteed response from the Kendo UI Team remains a private support thread.

Kind Regards,
Alex Hajigeorgieva
Progress Telerik

Hi Alex,

I already know about result = result and just result is same. The result part of the reply is actually a list of my model. How do I redefine this as schema in the grid? I'm told it'll benefit me in filtering... the original issue I'm facing. Just write the grid for me with my API's  return

Hi, Hassan,

Can you share a screenshot of the response from DevTools like this:

Alternatively, you can copy and paste the result as text and I will be able to use a mock service to show you how to bind the grid correctly.

Regards,
Alex Hajigeorgieva
Progress Telerik

Hello, Hassan,

Thank you for the screenshots.

It is clear that the response is not in an object - this means that removing the schema data and schema total will bind the grid correctly. Note that we have schema.model.fields

https://docs.telerik.com/kendo-ui/api/javascript/data/datasource/configuration/schema#schemamodel

dataSource: {
    schema: {
        model: {
            fields: {
                ParkingCardId: {
                    type: "number"
                },
                StaffNo: {
                    type: "string"
                },
                AirportPassNumber: {
                    type: "string"
                },
                Name: {
                    type: "string"
                },
                Status: {
                    type: "number"
                },
                PassIssueDate: {
                    type: "date"
                },
                PassExpiryDate: {
                    type: "date"
                },
                ServiceCode: {
                    type: "number"
                },
                TerminalId: {
                    type: "number"
                }
            }
        }
    },
    transport: {
        read: {
            url: window.BASE_URL + "Ajax/GetPassInfo",
            type: "get",
            dataType: "json",
            data: {
                lookupType: lookupType.value(),
                lookupValue: $("#LookupValue").val()
            }
        }
    },
    pageSize: 10
},

Kind Regards,
Alex Hajigeorgieva
Progress Telerik