jQuery Grid Plugin - jqGrid - Topic: json reader

xworker on json reader

Wed, 30 Dec 2009 11:25:23 +0200

I think I got it. It was how the json was outputed on the server. I was missing some ".

Thanks for all the help.

xworker on json reader

Wed, 30 Dec 2009 11:07:38 +0200

I have read the docs. The say I should set it to false? I cant get the example below to work either…

http://www.trirand.com/jqgridw.....#json_data

jQuery(“#gridid”).jqGrid({
…
jsonReader : {
root:“invdata”,
page: “currpage”,
total: “totalpages”,
records: “totalrecords”,
repeatitems: false,
id: “0″
},
…
});

The resulting data in our example should be:

{
totalpages: “1″,
currpage: “1″,
totalrecords: “2″,
invdata : [
{invid:"1",invdate:"cell11", amount:"cell12", tax:"cell13", total:"1234", note:"somenote"},
{invid:"2",invdate:"cell21", amount:"cell22", tax:"cell23", total:"2345", note:"some note"}
]
}


My script for displaying the data above:

jQuery(”#table”).jqGrid ({
url:'stats?player=x',
datatype : 'json',
mtype:'POST',

colNames:['invid','invdate','amount','tax','total','note'],
colModel : [
{name:'invid', width:30, sortable:true, align:'center'},
{name:'invdate', width:40, sortable:false, align:'center'},
{name:'amount', width:180, sortable:true, align:'left'},
{name:'tax', width:380, sortable:true, align:'left'},
{name:'total', width:0, sortable:false, align:'center'},
{name:'note', width:0, sortable:false, align:'center'}
],
sortname: “invid”,
sortorder: “asc”,
pager: '#pager',
rowNum:15,
rowList:[15,30,50],
caption: 'example',
viewrecords:true,

jsonReader : {
root:”invdata”,
page: “currpage”,
total: “totalpages”,
records: “totalrecords”,
repeatitems: false,
id: “0″
},

width: 700,
height: 200
});

Doesnt work. Thanks for helping.

tony on json reader

Wed, 30 Dec 2009 10:52:04 +0200

Hello,

Set repeaitems to true. Please read the docs before posting

http://www.trirand.com/jqgridw.....#json_data

Regards

Tony

xworker on json reader

Wed, 30 Dec 2009 10:46:53 +0200

Hi all

I'm having trouble with getting my json reader to work. This is the example output from my server:

{"page":"1","total":1,"records":"3","rows":[{"1","a","b","c","0"},{"2","aa","bb","cc","0"},{"3","aaa","bbb","ccc,"0"}]}

My jsonreader is like this:

jsonReader : {
        root: "rows",
        page: "page",
        total: "total",
        records: "records",
        repeatitems: false,
        id: "0"

Can someone see whats wrong?

Thanks