Guriddo » Topic: Sorting with Paging

Sorting with Paging

Guriddo
Sorting with Paging

This topic has 8 replies, 4 voices, and was last updated 16 years, 7 months ago by admin.

Creator

Topic
October 21, 2009 at 1:32 pm #74419

josh
Participant

With paging enabled, if I jump to page 3 and then change the sort order by clicking a column, the sorting changes and I am sent back to page 1.
Creator

Topic

Viewing 8 replies - 1 through 8 (of 8 total)

Author

Replies
October 23, 2009 at 11:42 am #89981

tony
Keymaster

Hello,

Look at onSortCol event. It will do the job.

Regards

Tony

October 26, 2009 at 10:36 am #90007

josh
Participant

OK – I can set the page within onSortCol and the list jumps to that page after sorting:

onSortCol: function(index,iCol,sort){jQuery(“#list”).setGridParam({page:3});

However, I obviously don't want to hard-code the page number… and instead it should be set depending on what page I'm on when I click the column to sort by.

October 26, 2009 at 11:11 am #90009

Rumen
Participant

Yes, the page the grid is currently on is accessible in the property (option, in jQuery UI terms) “page”. To access it, use something like that

var grid = $(“#myGridID”);

var page = grid.getGridParam('page')

then pass the page variable on with the sort events.

October 26, 2009 at 1:11 pm #90013

josh
Participant

Right… I had tried that.

October 26, 2009 at 1:16 pm #90014

josh
Participant

I suppose that I could keep track of the page number by creating a variable for currentPage and then doing something like:

onPaging: function() { currentPage = $('#list').getGridParam('page'); },

onSortCol: function() { jQuery('#list').setGridParam({page:currentPage});

But is there a cleaner way??

October 27, 2009 at 3:58 am #90046

tony
Keymaster

Hello,

The solution is a little bit tricky.

onSortCol: function(index,iCol,sort){

var postpage = jQuery(”#list”).getGridParam('postData');

jQuery(”#list”).setGridParam({page:postpage.page});

}

Regards

Tony

October 27, 2009 at 12:17 pm #90068

josh
Participant

Perfect.

October 28, 2009 at 9:21 am #90090

admin
Keymaster

yeah it stayed at the current page but the data.. but it sorts all the data not the data within the selected page. is there any way to sort the data in the selected page?

for instance i have an alphabet table:

im in page 2 and the data in the table are-

p

s

t

r

and i want to sort those data and it would be like:

p

r

s

t

not like:

a

b

c

d

or

w

x

y

z
Author

Replies