How to retrive filtered Data From DB Server with refresh button

[Flavio]

I evaluating your component.

I need to retrive filtered data with custom filter into custom header with refresh button click

Client:

.Pageable(p => p.Refresh(true))

.Sortable()

.Selectable()

.Scrollable(scrollable => scrollable.Height(30))

.Filterable()

.HtmlAttributes(new { style = "height:550px;" })

.DataSource(dataSource => dataSource

.Ajax()

.PageSize(20)

.Model(model => model.Id(p => p.Id))

.ServerOperation(true)

.Read(create => create.Action("IncomingRead", "Grid", new { topRow = ""}))

)

Server:

public ActionResult IncomingRead([DataSourceRequest]DataSourceRequest request)

 

 

{

 

string virtualPath = "";

var customerWhereCondition = "";

var userIdWhereCondition = "";

var versionNumberWhereCondition = "";

var json = Helper.GetDataFromDb(virtualPath, 100, "-1", customerWhereCondition,

userIdWhereCondition, versionNumberWhereCondition, new DateTime(2015, 4, 1), DateTime.Now);

return Json(json.ToDataSourceResult(request));

 

 

}

 

 

how to set filter into request object(client) and get filter into the server for execute new query?

 

thankyou in advance.

Regards,

Flavio

 

 

[Maria Ilieva]

Hello Flavio,

You should use the DataSource API to get the filter expression on the server, like this:

http://docs.telerik.com/kendo-ui/api/javascript/data/datasource#methods-filter

and after having the expression you can transform it to a custom Where condition per your needs.

Regards,
Maria Ilieva
Telerik