Can the total number of records not include subtotal record

[datafor]

Hi
      Here is my problem：We use the remote paging. In each page there will be several detail records, and several subtotal records which are also calculated by the server side. Can the total records not count subtotal records？
      Thanks!

[paramvir]

Total records count all kind of rows except in fixed rows at bottom, it can't be prevented.

[datafor]

Thanks for your reply.
So, is it possible to keep the totals records from counting some of the specified rows in every page? Setting configurations or calling pqGrid api, or extending pqGrid by adding custom scripts, or otherwise？

[paramvir]

Any rows in summaryData option are not counted in total rows in grid.

https://paramquery.com/pro/api#option-summaryData

Example of usage of summaryData: https://paramquery.com/pro/demos/summary_json

[paramvir]

This workaround can be used

Add extra rows in dataReady event.

Code: [Select]

dataReady: function(evt, ui){
        //add any extra rows here by array manipulation of pageData.
this.pageData().unshift({});
},


Please note that being a workaround it may or may not work properly in upcoming versions.