JqGrid not loading data from JSON
I have a JQGrid plugin in my website, the table is loading OK, but with no-rows to edit, select or whatever. It is requesting the server because when i watch the log I see the request and it's parameters (sidx, _search,开发者_Go百科 rows, sord, nd, etc).
This is the jqgrid code:
$(document).ready(function() {
var lastsel;
jQuery("#rowed3").jqGrid(
{
url : CONTEXT_PATH+'/ajax/getPartesByCategory.do?catid=<s:property value="categoryId" />',
datatype: 'json',
colNames : [ 'piezaId', 'descripcion', 'disponible'],
colModel : [ {
name : 'piezaId',
index : 'piezaId',
align : "right",
width : 40
}, {
name : 'descripcion',
index : 'descripcion',
width : 360,
editable : true
}, {
name : 'disponible',
index : 'disponible',
width : 80,
editable : true
} ],
rowNum : 20,
rowList : [ 20, 40, 60, 80 ],
pager : '#prowed3',
sortname : 'id',
viewrecords : true,
sortorder : "desc",
onSelectRow : function(id) {
if (id && id !== lastsel) {
jQuery('#rowed3').jqGrid('restoreRow', lastsel);
jQuery('#rowed3').jqGrid('editRow', id, true);
lastsel = id;
}
},
editurl : "server.php",
caption : "Piezas"
});
jQuery("#rowed3").jqGrid('navGrid', "#prowed3", {
edit : false,
add : false,
del : false
});
})
This is the JSON that the server returns:
[{
"piezaId": 486,
"disponible": 1,
"descripcion": "Asiento delantero LH",
"category": {
"categoryId": 2,
"category": "Interior",
"status": 1,
"subCategories": []
}
}, {
"piezaId": 485,
"disponible": 1,
"descripcion": "Asiento delantero RH",
"category": {
"categoryId": 2,
"category": "Interior",
"status": 1,
"subCategories": []
}
}]
in the server side I'm using JAVA6, Struts2 and GSon to write the json, but for these ajax calls im only writing to the response a text/plain content
Any help?
You should either change format of data send from the server or use some jsonReader
or jsonmap
technique (see for example jquery with ASP.NET MVC - calling ajax enabled web service or http://www.trirand.com/jqgridwiki/doku.php?id=wiki:retrieving_data#json_data and Mapping JSON data in JQGrid). The easiest way is to produce data which can be read with the standard jsonReader
(see http://www.trirand.com/jqgridwiki/doku.php?id=wiki:retrieving_data#json_data):
{
"total": "1",
"page": "1",
"records": "2",
"rows" : [
{"id" :"1", "cell":["486","1","Asiento delantero LH"]},
{"id" :"2", "cell":["485","1","Asiento delantero RH"]},
]
}
精彩评论