paging & sorting v2.5

I am trying to load in 20,000 rows of data, I only wish to display 20 rows at a time, but when I sort I want the whole 20,000 rows to be sorted then display the 20 rows.

I understand how to set up 'virtual paging' using obj.setRowOffSet but sorting does not occur throughout the whole data array. Does anyone know of a way this can be achieved?

I have found a solution.

You will need to modify aw.js to get this working. In AW.Grid.Controllers.Sort

a variable 'count' is set to this.getRowCount(); you will need to change this to the actual count of all your rows. (This can be done by creating a global variable and setiing it on your page.)

You will then need to change all references to this.getRowCount() to your variable, excluding the one in

AW.Grid.Controllers.Overflow

I have only tested this with a basic grid that only needs to be sorted and paged and seems to work fine

correction, there is a bug. The array will sort fully on page one, however if you go to page 2 and sort it will ignore page 1, so if you sort the last page it will only sort the data for that page. looking for a fix, but if any one has any suggestions???