jQuery Grid Plugin - jqGridForum

Topic RSS

Empty Grid cells under 3.6 using json dot notation

08/05/2010
21:37

padams

New Member

Members

Forum Posts: 1

Member Since:
08/05/2010

Offline

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.

09/05/2010
13:05

tony

Sofia, Bulgaria

Moderator

Members

Moderators

Forum Posts: 7721

Member Since:
30/10/2007

Offline

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

For professional UI suites for Java Script and PHP visit us at our commercial products site - guriddo.net - by the very same guys that created jqGrid.

All RSS

Forum Timezone: Europe/Sofia

Most Users Ever Online: 715

Currently Online:
67 Guest(s)

Currently Browsing this Page:
1 Guest(s)