jQuery Grid Plugin - jqGrid - Topic: Sorting with Paging http://www.trirand.com/blog/?page_id=393/help/sorting-with-paging Simple:Press Version 5.7.5.3 pupian on Sorting with Paging http://www.trirand.com/blog/?page_id=393/help/sorting-with-paging#p11183 Help http://www.trirand.com/blog/?page_id=393/help/sorting-with-paging#p11183 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

]]> Wed, 28 Oct 2009 09:21:30 +0200 josh on Sorting with Paging http://www.trirand.com/blog/?page_id=393/help/sorting-with-paging#p11150 Help http://www.trirand.com/blog/?page_id=393/help/sorting-with-paging#p11150 Perfect.  Thank you.

]]> Tue, 27 Oct 2009 12:17:17 +0200 tony on Sorting with Paging http://www.trirand.com/blog/?page_id=393/help/sorting-with-paging#p11125 Help http://www.trirand.com/blog/?page_id=393/help/sorting-with-paging#p11125 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

]]> Tue, 27 Oct 2009 03:58:18 +0200 josh on Sorting with Paging http://www.trirand.com/blog/?page_id=393/help/sorting-with-paging#p11086 Help http://www.trirand.com/blog/?page_id=393/help/sorting-with-paging#p11086 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??

]]> Mon, 26 Oct 2009 13:16:38 +0200 josh on Sorting with Paging http://www.trirand.com/blog/?page_id=393/help/sorting-with-paging#p11085 Help http://www.trirand.com/blog/?page_id=393/help/sorting-with-paging#p11085 Right... I had tried that.  See my last post:

"When I call $('#list').getGridParam('page') from within the onSortCol function, it returns “1″ even if I'm on page 5."

I tested this by simply placing an alert($('#list').getGridParam('page')) inside the onSortCol function.  If I'm on, for example, page 5 and click a column to change the sort, the alert box displays "1", instead of "5" like I would have thought.  Any idea why or what I could try different?

]]> Mon, 26 Oct 2009 13:11:15 +0200 Rumen[Trirand] on Sorting with Paging http://www.trirand.com/blog/?page_id=393/help/sorting-with-paging#p11080 Help http://www.trirand.com/blog/?page_id=393/help/sorting-with-paging#p11080 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.

]]> Mon, 26 Oct 2009 11:11:22 +0200 josh on Sorting with Paging http://www.trirand.com/blog/?page_id=393/help/sorting-with-paging#p11078 Help http://www.trirand.com/blog/?page_id=393/help/sorting-with-paging#p11078 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.   How can I fetch the current page in order to set it in the setGridParam above?  When I call $('#list').getGridParam('page') from within the onSortCol function, it returns "1" even if I'm on page 5.

]]> Mon, 26 Oct 2009 10:36:55 +0200 tony on Sorting with Paging http://www.trirand.com/blog/?page_id=393/help/sorting-with-paging#p11040 Help http://www.trirand.com/blog/?page_id=393/help/sorting-with-paging#p11040 Hello,

Look at onSortCol event. It will do the job.

Regards

Tony

]]> Fri, 23 Oct 2009 11:42:28 +0300 josh on Sorting with Paging http://www.trirand.com/blog/?page_id=393/help/sorting-with-paging#p10959 Help http://www.trirand.com/blog/?page_id=393/help/sorting-with-paging#p10959 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.  Is there a way to retain the page that I am on when the sort order changes?  In other words, when I am on page 3 and I change the sort order, I'd like to stay on page 3.

Thanks.

]]> Wed, 21 Oct 2009 13:32:26 +0300