jQuery Grid Plugin - jqGrid - Topic: Footer summary JSON format

Vinoth on Footer summary JSON format

Mon, 21 Sep 2009 13:55:15 +0300

Tony,

thanks for your reply. I am using the below script at the grid configuration level and the data from server.

jsonReader:{
root: 'itemrows',
page: 'currentpage',
total: 'totalpages',
records: 'pagerecords',
userdata: 'SummaryData'
},

-------------

{totalpages: '2',
currentpage: '1',
pagerecords: '14',
SummaryData: {CheckAmt: '22.60'}
itemrows: [{Id:'941', CheckAmt:'10.00' },{Id:'951', CheckAmt:'5.00' },{Id:'952', CheckAmt:'2.60' },{Id:'957', CheckAmt:'5.00' } ]}

Please advise.

thanks,

Vinoth

tony on Footer summary JSON format

Mon, 14 Sep 2009 23:14:41 +0300

Hello,

You should provide the additional information in user data array where the summs are here or use the getCol method to summ the needed row and put the info with footerData method.

Regards

Tony

Vinoth on Footer summary JSON format

Mon, 14 Sep 2009 15:40:15 +0300

Hello,

I am trying to show columnm summary on the footer. I have enabled footerrow : true, userDataOnFooter : true at the grid configuration. I have the summary information from the code base and wondering if anyone can help me on how to pass the summary information to the client as JSON object.

Here is the json format, I use to display the data.

{totalpages: '2', currentpage: '1', pagerecords: '14',itemrows: [
{Id:'941', CheckAmt:'10.00' },
{Id:'951', CheckAmt:'5.00' },
{Id:'952', CheckAmt:'2.60' },
{Id:'957', CheckAmt:'5.00' } ]}

How can I pass the total amount to the client with the json strng. CheckTotalAmt: '22.60'

- thanks

Vinoth