Preload filterable data

[Ed]

In my grid, I am using filterable and the data is fetched asynchronously when the user clicks on the down arrow in the column header. I would like to pre-fetch that data as soon as the grid data is requested - so that the user will most likely not see the spinner while the user waits for data.  Currently, the data is not requested until the user clicks on the down arrow.

 

The column configuration is as follows:

 

{ field: "CompanyName", title: "Company Name", width: 168, filterable: { multi: true, dataSource: { transport: { read: { url: "/api/LoadGridDataUnique", data: { field: "CompanyName"}}}}} }

[Ed]

I tried the following after the call to initialize the grid, but got ​the error: Uncaught TypeError: val.filterable.dataSource.read is not a function

So, how do I prefetch the filterable data for the multi filterable dropdowns?

var grid = $("#myGrid").data("kendoGrid");
$.each(grid.columns, function(idx, val) {
    if (val.filterable && val.filterable.dataSource) {
        val.filterable.dataSource.read();
    }
});

[Boyan Dimitrov]

Hello Ed,

The filtermulticheck widget is initialized for each column header (th) element. So basically if you have a column "FirstName"in your Kendo UI Grid in order to call the read method for the filtermulticheck widget use the following code: 

$("th[data-field='FirstName']").data().kendoFilterMultiCheck.checkSource.read()

 

 

Regards,
Boyan Dimitrov
Telerik