JqGrid not loading data from JSON

Question

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, 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?

Answer 1

You should either change format of data send from the server or use some jsonReader or jsonmap technique (see for example http://stackoverflow.com/questions/2835957/jquery-with-asp-net-mvc-calling-ajax-enabled-web-service/2836817#2836817 or http://www.trirand.com/jqgridwiki/doku.php?id=wiki:retrieving_data#json_data and http://stackoverflow.com/questions/2690657/mapping-json-data-in-jqgrid/2706620#2706620). 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"]},
  ]
}