Re: sorting the data for the current page in server side pagination
>This is an interesting problem. I can't say I understand what application this would be a natural user experience for, but here's what you'll need to do:
> I am using YUI server side pagination using JSON. Now I wanted to sort the each page separately on clicking of the table header. I know I can do the sorting for the entire data set. But sorting the data for the current page (only for the current page)is a challenge. Does any body have a suggestions?
1) Create markup to contain the Paginator(s) and the DataTable separately
2) Instantiate a Paginator. Set the Paginator's "containers" config, pointing to the element(s) you included in the markup
3) Subscribe to the Paginator's changeRequest event. In the callback, issue a sendRequest to your DataSource using the state.recordOffset from the state argument passed to the callback
4) Instantiate the DataTable being sure that the dynamicData config is NOT being set (it defaults to false) and do NOT pass the Paginator in the configuration. Set whichever columns you like to be sortable.
If you know already how many records you will be paging through, pass that in your Paginator's totalRecords config at construction. If you don't know the total number of records until the server responds, you'll need to override the DataSource's doBeforeParseData method to set the Paginator's totalRecords attribute.
This is all pretty convoluted, but hey, you're asking for a pretty convoluted set up :)
I put together this code, which works for me:
Hope this helps,