I'm using v. 3.7 with mvc 2.0 and I have the same problem,

I tried your solution, the pager works.

but when sorting, nothing happens!

this is my code, can u tell me why does'nt it work?

Thanks!

Same thing happens with gridComplete.

When you click on sort column, it will eventually call populate(). populate() will call addLocalData() (since datatype is changed to 'local' in gridComplete). However, addLocalData() will return empty result set as ts.p.data is empty and subsequent call to addJSONData() will result in empty grid.

Even forcing population of ts.p.data in addJSONData() will not work - addLocalData() will change number of pages/records to that of ts.p.data array and that will disable paging - ts.p.data will have only one page of data as paging is on server side.

Erik

Try with gridComplete event instead of loadComplete

Regards

Looking at the code, in case of 'datatype: json' (or xml and maybe others), no data is stored on the client side (in ts.p.data) unless 'loadonce: true' is specified. But if you specify 'loadonce: true', paging is disabled.

The 2 scenarios:

datatype: json, loadonce: false

• paging works (serverside)
• sorting does not work (after doing sort, grid is empty)

datatype: json, loadonce: true

• paging is disabled
• sorting works (clientside)

Erik

    I am trying to do clientside sorting and server side paging but I am using

datatype: function(){....}

when I try the method

loadComplete: function(){
        grid.setGridParam({datatype:'local'});
    },

it doesn't seem to work for me.  

Is this because of the original def as a function?

thanks for any help

B

It is wired. If you use loadonce : true

why do you use these? - this is not needed. Please look what loadonce do.

Actually you do not need to do anything in this case

Regards

Everthing is OK IMHO, but you will need to remove the reloading the grid.

It is done automatically.

There is example here:

http://www.trirand.com/jqgridw.....ide_paging

Regards

The paging works but when I try to sort a field it blanks out the entire grid.

$(document).ready(function(){
      $("#mygrid").jqGrid({
        url:'http://localhost/data',
        datatype: 'json',
        mtype: 'GET',
        colNames:['ID', 'User'],
        colModel :[ 
            {name:'id', jsonmap: 'cell.id', sorttype:'int'},
            {name:'user', jsonmap: 'cell.user', sorttype:'text'},            
        ],
        jsonReader: { repeatitems: false },
        pager: '#mypager',
        viewrecords: true,
        rowNum:30,
        rowList:[30,100,1000],
        gridview: true,
        viewrecords: true,
        sortable:true,        
        sortorder: 'desc',        
        height: "100%",
        scrollOffset:0,  
        onSelectRow: function(id){ 
         },          
        altRows     : true,
        altclass    : 'oddRow',
        gridComplete: function() {
            $(".jqgrow:odd").hover(
                function() { $(this).removeClass("oddRow");}, 
                function(event) { $(this).addClass("oddRow");}
            );
        }, 
        onPaging: function() {
            $("#mygrid").setGridParam({datatype:'json'});
            $("#mygrid").trigger("reloadGrid");
            },               
        loadComplete: function () {        	
        	$("#mygrid").setGridParam({datatype:'local'});
        	$("#mygrid").trigger("reloadGrid");
        	}, 	
      }); 
      
      $('#mygrid').jqGrid('filterToolbar', { searchOnEnter: true, enableClear: false });
    });

Hope u guys have been rocking for jqgrid.

Here it is, my requirenment is about the client side paging.

Is there a way to do a client side paging when we go for loadonce:true?

thanx in advance, kishore.

tony said:

Hello,

The solution is a little tricky.

1. Set your default datatype to json or xml.

2. define loadComplete event like this

loadComplete: function () {

$("#mygrid").setGridParam({datatype:'local'});

}

3. define onPaging event like thiss

onPaging : function(which_button) {

$("#mygrid").setGridParam({datatype:'json'});

}

Enjoy!

Do not forget to set sorttype in colModel in order to sort work correct

Regards

Tony

Thanks, this works for me!

Not sure if this will be default. In this case the developers should place additional the sorttype option and etc.

Also it is good that you have to do this with minimal code.

The main concept of jqGrid is not to give ready solutions, but rather possibility to do evrething what you want.

Regards

Tony

Also, I tried using Tony's suggestions above (toggling the grid between local and xml) and while they seemed to work, I had major problems. On some of the grid pages (maybe just the last page?), when sorting, the columns would become different sizes than the headers. I also encountered an issue where I clicking on the next button in the pager took me back several pages. But then clicking again would start to advance me in the right direction. I finally had to give up.

The on pagging event have the same place - in jqGrid parameters

Regards

Tony

jQuery("#list2").jqGrid({

section, but I'm not sure about what needs to be modified in the onPaging part. Can someone provide me with an example?

Thanks!

This solution worked.

Regards,

Sam

I will try this out and let you know if it works.

Regards,

Sam

The solution is a little tricky.

1. Set your default datatype to json or xml.

2. define loadComplete event like this

loadComplete: function () {

$("#mygrid").setGridParam({datatype:'local'});

}

3. define onPaging event like thiss

onPaging : function(which_button) {

$("#mygrid").setGridParam({datatype:'json'});

}

Enjoy!

Do not forget to set sorttype in colModel in order to sort work correct

Regards

Tony