jqgrid client side sorting with server side paging – data disappears

by

First of all I want repeat that I don’t recommend you to use local sorting and the server side paging. I find that the user can wrong interpret the result of sorting.

Nevertheless, if your customer agree with restriction which have the combination of local sorting and the server side paging and if you really need to implement that, I can suggest you the following solution:

onPaging: function() {
    $(this).setGridParam({datatype: 'json'}).triggerHandler("reloadGrid");
},
loadComplete: function (data) {
    var $this = $(this);
    if ($this.jqGrid('getGridParam', 'datatype') === 'json') {
        // because one use repeatitems: false option and uses no
        // jsonmap in the colModel the setting of data parameter
        // is very easy. We can set data parameter to data.rows:
        $this.jqGrid('setGridParam', {
            datatype: 'local',
            data: data.rows,
            pageServer: data.page,
            recordsServer: data.records,
            lastpageServer: data.total
        });

        // because we changed the value of the data parameter
        // we need update internal _index parameter:
        this.refreshIndex();

        if ($this.jqGrid('getGridParam', 'sortname') !== '') {
            // we need reload grid only if we use sortname parameter,
            // but the server return unsorted data
            $this.triggerHandler('reloadGrid');
        }
    } else {
        $this.jqGrid('setGridParam', {
            page: $this.jqGrid('getGridParam', 'pageServer'),
            records: $this.jqGrid('getGridParam', 'recordsServer'),
            lastpage: $this.jqGrid('getGridParam', 'lastpageServer')
        });
        this.updatepager(false, true);
    }
}

If you would don’t use repeatitems: false the code which fills data parameter of jqGrid will be a little longer, but it will work.

More Related Contents:

  1. How to filter the jqGrid data NOT using the built in search/filter box
  2. Why is gridview:true used for and what does it mean?
  3. jQuery table sort
  4. jqGrid paging question
  5. jqGrid: Disable form fields when editing
  6. JqGrid need hyperlink – need to capture value through Jquery
  7. Linking from a column value in jqGrid to a new page using GET
  8. Randomize a sequence of div elements with jQuery
  9. How to adjust the column width of jqgrid AFTER the data is loaded?
  10. What is the easiest way to order a / in jQuery?
  11. How to use free jqgrid properties to conditionally add actions buttons
  12. jqGrid dynamic column binding
  13. jqGrid: using beforeProcessing to populate filterToolbar selection boxes
  14. jqGrid resolve the grid pager ID dynamically?
  15. Can jqGrid hover text be defined with AddRowData?
  16. jqgrid showLink
  17. How to read userData in jqgrid?
  18. How can i get jqgrid frozen columns to work with word wrap on
  19. How do I change selected value of select2 dropdown with JqGrid?
  20. Multiple search with multiplefields by default
  21. jqGrid : issue loading nested sub grid with local datatype
  22. How to make Jqgrid frozen column word-wrap
  23. Jquery JQGrid – How to set alignment of grid header cells?
  24. jqGrid auto filter highlighting search result
  25. jqgrid nested subgrid 4th level subgrid always returns first rowid of the subgrid
  26. How to edit the selected cell on jqGrid
  27. jQuery modal dialog and jqGrid
  28. why doesn’t Jqgrid frozen column seem to work with filter rows and filter heading?
  29. JqGrid Filter Rules – Can we filter based on an Array?
  30. How can I change the background color of a cell in a jqgrid custom formatter?

Leave a Comment