[Solved] Server Filtering using DataSourceRequest in MVC API

[Andrew]

Hi,

I am having problem with server filtering in my mvc api controller. The DataSourceRequest Filter is null when I look at the request variable but if I enable server paging I can see the pagesize is being set. The model returns ok but with no filtering.
I have checked in Fiddler the request header and the filter is there, see below.

GET /api/Event?callback=jQuery19100650028504896909_1419384451525&filter%5Blogic%5D=and&filter%5Bfilters%5D%5B0%5D%5Bfield%5D=StateID&filter%5Bfilters%5D%5B0%5D%5Boperator%5D=eq&filter%5Bfilters%5D%5B0%5D%5Bvalue%5D=7&_=1419384451528 HTTP/1.1


MVC API Controller Code
public DataSourceResult GetEvents([ModelBinder(typeof(WebApiDataSourceRequestModelBinder))]DataSourceRequest request)
{
    return db.carEvent.ToDataSourceResult(request); 
}

Cordova App Code
var dataSource = new kendo.data.DataSource({
            transport: {
                read: {
                    url: "http://localhost:57459/api/Event",
                    dataType: "jsonp"
                }
            },
            schema: {
                data: "Data",
                model: {
                    ID: "id",
                    fields: {
                        ID: { type: "number" },
                        Event: { type: "string" },
                        Location: { type: "string" },
                        Information: { type: "string" },
                        StateID: { type: "number" },
                        EventDate: { type: "date" }
                    }
                }
            },
            serverFiltering: true,
            filter: { field: "StateID", operator: "eq", value: StateValue }
        });

Thanks Andrew

[Petur Subev]

Hello Andrew,

Could you please check the following project which demonstrated WebAPI binding through JavaScript configuration.

https://github.com/telerik/ui-for-aspnet-mvc-examples/tree/master/grid/webapi-crud

I noticed you are missing the parameterMap function. Fine tune your case according to the example and if struggling please demonstrate your case with a small isolated example.

Kind Regards,
Petur Subev
Telerik

 

 

[Andrew]

Hi Petur,

Thanks for the reply.
I downloaded the example you provided into Visual Studio but there is no example of the ParameterMap Function in JavaScript, there is only a Razor Kendo Grid HTML helper .

Thanks
Andrew

[Alexander Popov]

Hello Andrew,

Here is an example project which is not using the ASP.NET MVC wrappers. You can also examine the rest of the examples in the same repository.

Regards,
Alexander Popov
Telerik