DataSource Read called twice

[Martin]

I am presenting the user with a text box in which they can enter a search term. When the search term changes I call the following script.

function fillGrid() {

    var grid = $("#Grid").data("kendoGrid");

    $("#ActionError").html("");

    grid.dataSource.page(1);

    grid.dataSource.read();

}

Let's say the original search term causes 10 pages to be displayed and that we are viewing page 10. So we are viewing, 190 of 200. And let's say the new search term only produces 100 items, what happens is that the grid is empty and the bottom line indicates we are viewing 190 of 100. Refreshing the grid corrects the problem, but I added the line "grid.dataSource.page(1);" above to do this automatically. But I have observed that this has the side effect of calling the Controller twice. Generally, I used grid.dataSource.read() to refresh the grid. So I am wondering what is the correct way to perform this operation so that I don't make two calls to the database. I guess that every time the grid is changed it updates. Is there a way to turn updating off, make changes to the grid, and then refresh it. 

[Nikolay Rusev]

Hello Martin,

I suspect that what you need is to call DataSource.query method and provide the parameters. For example to page on first page with page size 10 and filter expression you will need the following expression:

<DataSource instance>.query({
 page: 1,
 pageSize: 10,
 filter: { operator: ">", field: "OrderID", value: 10248 }
})

Regards,
Nikolay Rusev
the Telerik team

[Linda]

Hi

I have the same problem and try with <DataSource instance>.query .... but doesn't work

This is my code:

 // Restore the selected grid page.
                var pageToSelect = 0;
                gridSource.one('change', function (e) {
                    var currentPage = gridSource.page() || 1,
                        totalPages = gridSource.totalPages();

                    //gridSource.page(currentPage < totalPages ? currentPage : totalPages);
                    pageToSelect = currentPage < totalPages ? currentPage : totalPages;
             
                });

                gridSource.query({
                    page: pageToSelect,
                    pageSize: 10,
                });
                gridSource.read(); // READ

[Preslav]

Hi Linda,

I believe that this behavior is caused by the read method of the dataSource. Remove the last line of the provided code and only a single read will be called.

If this is not the case, in order to continue my investigation, please send as an isolated Dojo that clearly replicates the issue. I will use it to fully understand the scenario and provide assistance to the best of my knowledge.

Regards,
Preslav
Progress Telerik