I am using a grid with loadOnce:true in order to have only one query to the server. The data is sorted on server side (multi-column sorting). Sorting is disabled on client side.
Before activating the grouping feature, navigation was working correctly.
By activating the grouping feature, the first page is OK. But when I go to the next page with the navigation button, the data is sorted on client-side according to the grouping column (even with groupDataSorted:true).
rowTotal: 10000,
gridview: true,
scroll: false,
loadonce: true,
pgbuttons: true,
pginput: true,
rowNum: 100,
rowList: '',
datatype: 'json',
mtype: 'GET',
grouping: true,
groupingView : {
groupField : ['prodNo'],
groupSummary: [true],
groupColumnShow: [false],
groupText: ['({1})'],
showSummaryOnHide: true,
groupDataSorted : true,
groupCollapse: false
},
jsonReader: {root: 'list', userdata : 'list'},
url:'...'
My case is a bit special because I am sorting the data on server side according to a 'name' and 'date' columns, but grouping rows according to another 'prodNo' column. However I do not understand why the sorting is done on page navigation.
Is there a way to disable this client-side sorting on page navigation ?
thanks in advance