So I was playing around with KendoUI and incorporated Dynamic LINQ Helpers in my ASP.NET MVC project. I followed the small tutorial here.
So far, the paging and sorting is working fine but the filtering is not working. Every time I try to filter my records, there is an exception on server side like the following
Operator '=' incompatible with operand types 'String' and 'String[]'
Can anyone help me with this?
Here is my Grid code (yes I am using Angular)
$scope.mainGridOptions = { dataSource: { transport: { read: { url: ConfigData.BaseUrl + "ChartOfAccounts/GetData", type: 'post', dataType: "json" }, update: { url: ConfigData.BaseUrl + "ChartOfAccounts/UpdateData", type: "post", dataType: 'json' }, create: { url: ConfigData.BaseUrl + "ChartOfAccounts/CreateData", type: "post", dataType: 'json' }, destroy: { url: ConfigData.BaseUrl + "ChartOfAccounts/DeleteData", type: "post", dataType: 'json' } }, serverPaging: true, serverFiltering: true, serverSorting: true, pageSize: 5, batch: true, schema: { data: "Data", total: "Total", model: { id: "ID", fields: { ID: { type: "number" }, AccountNumber: { type: "string" }, AccountName: { type: "string" } } } } }, columns: [ { field: "AccountNumber", title: "Account Number", width: "130px" }, { field: "AccountName", title: "Account Name", width: "130px" } ] };