I can't seem to get data to appear in cells for of my grid when using json dot notation under 3.6. here is my json:
{"timePeriod:
{"period":
"this_week",
"startDate":"20100502",
"endDate":"20100509",
"startTime":1272783600,
"endTime":1273388400,
"label":"This Week"
},
"resultsPerPage":null,
"resultsTotal":null,
"resultsReturned":13,
"resultsRows":[
{"actionName":
{"result_type":"dimension",
"name":"actionName",
"value":"comment",
"label":"Action Name",
"data_type":"string"
},
"actions":
{"result_type":"metric",
"name":"actions",
"value":"1",
"label":"Actions",
"data_type":"integer"
}
},
{"actionName":
{"result_type":"dimension",
"name":"actionName",
"value":"created",
"label":"Action Name",
"data_type":"string"
},
"actions":
{"result_type":"metric",
"name":"actions",
"value":"4",
"label":"Actions",
"data_type":"integer"
}
],
"labels": {
"actions":"Actions",
"actionName":"Action Name"
},
"more":null,
"page":1,
"total_pages":null,
"self":null,
"next":null,
"results_count":13,
"offset":0,
"limit":null,
"query_limit":null,
"module":"base"
}
here is my jqgrid setup:
jQuery("#grid").jqGrid({
url:'…',
jsonReader: {
//repeatitems: false
root: "resultsRows",
cell: ''
},
datatype: "json",
colModel:[
{name:'actionName.value',
index:'actionName.value',
label:'Action Name',
sorttype:'text'
},
{name:'actions.value',
index:'actions.value',
label:'Actions',
sorttype:'int',
align:'right'
}
],
rowNum:2,
viewrecords: true,
//caption: "My Caption",
height: '100%'
});
The grid renders but the cells are blank. Any idea what I am missing?
I could not get it to work either useing datatype: clientSide or local.
Copyright 2014 TriRand LtdAll Rights ReservedRSS
Back to Top