Guriddo » Topic: Using Client Side Sorting But Server Side Paging using JQGrid

Using Client Side Sorting But Server Side Paging using JQGrid

Guriddo
Using Client Side Sorting But Server Side Paging using JQGrid

This topic has 20 replies, 11 voices, and was last updated 14 years, 3 months ago by beMe.

Creator

Topic
May 25, 2009 at 11:04 am #73410

sam1980s
Participant

Hi,

1. Requirement :
In my project most of grids need to have client side sorting . so lets say i have 10 records on client side when i sort only those 10 records will be sorted.
But I need server side paging.

Solution :
I can achieve this by using loadonce : true in jqgrid. And providing some other server side pager control.

Problem :
1. Can I achive client side sorting and server side paging both using JQGrid.

2. When i set the load once to true the paging gets disabled. I wants to provide some kind of jquery paging also. So when i click on next page it will fetch the next say 10 records from the server.

Regards,

Sam
Creator

Topic

Viewing 15 replies - 1 through 15 (of 20 total)

1 2 →

Author

Replies
May 25, 2009 at 12:58 pm #87001

tony
Keymaster

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

May 25, 2009 at 1:50 pm #87002

sam1980
Participant

Thanks Tony for your help.

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

Regards,

Sam

May 26, 2009 at 1:46 am #87007

sam1980s
Participant

Thanks Tony.

This solution worked.

Regards,

Sam

June 30, 2009 at 9:27 am #87465

riverguardian
Participant

Would it be possible to elaborate on this? I understand that the loadComplete: function has to be included in the

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!

July 2, 2009 at 2:48 am #87498

tony
Keymaster

Hello,

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

Regards

Tony

September 8, 2009 at 6:35 pm #88849

admin
Keymaster

It seems to me that this should be the default behavior of jqGrid. Why do you want the latency and performance hit of a round trip to the server just to sort data? Perhaps there should be an option to allow server-side sorting for those that need it, but by default, the client should sort.

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.

September 10, 2009 at 4:11 am #88893

tony
Keymaster

Hello,

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

October 28, 2009 at 9:46 am #90091

admin
Keymaster

this topic solves my problem in my school project.. thank you very much. i wish someday i could be as good as you guys.

August 18, 2011 at 2:45 am #98652

dinesh
Participant

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!

November 24, 2011 at 9:27 am #99108

kishore
Participant

Hi Tony,

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.

November 30, 2011 at 6:16 am #99131

newtonianb
Participant

I tried that but it's not working. 4.2.0

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

1

November 30, 2011 at 1:07 pm #99132

tony
Keymaster

Hello,

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/jqgridwiki/doku.php?id=wiki:howto_grid_base#client_side_sorting_but_server_side_paging

Regards

November 30, 2011 at 7:11 pm #99134

newtonianb
Participant

I did this exactly and the paging works but when I try to do the search or the sorting by column field the entire data in the grid dissapears!

November 30, 2011 at 7:22 pm #99135

newtonianb
Participant

If I do loadonce: true paging no longer works but sorting and searching works

November 30, 2011 at 8:23 pm #99137

tony
Keymaster

Hello,

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
Author

Replies