jQuery Grid Plugin - jqGrid - Topic: Empty Grid cells under 3.6 using json dot notation http://www.trirand.com/blog/?page_id=393/help/empty-grid-cells-under-3-6-using-json-dot-notation Simple:Press Version 5.7.5.3 tony on Empty Grid cells under 3.6 using json dot notation http://www.trirand.com/blog/?page_id=393/help/empty-grid-cells-under-3-6-using-json-dot-notation#p17021 Help http://www.trirand.com/blog/?page_id=393/help/empty-grid-cells-under-3-6-using-json-dot-notation#p17021 Hello,

Just copy paste you r code and the only change that bring the grid to work is to set repeatitems to false - i.e.

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%'
});

This work well in my demo.

Best Regards

Tony

]]> Sun, 09 May 2010 13:05:17 +0300 padams on Empty Grid cells under 3.6 using json dot notation http://www.trirand.com/blog/?page_id=393/help/empty-grid-cells-under-3-6-using-json-dot-notation#p17018 Help http://www.trirand.com/blog/?page_id=393/help/empty-grid-cells-under-3-6-using-json-dot-notation#p17018 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.

]]> Sat, 08 May 2010 21:37:55 +0300