json - jqGrid devuelve celdas en blanco

jsonp google-fusion-tables

Question

Parece que no puede obtener el siguiente código jqGrid para trabajar http://cablegate.politicswiki.ie/stackoverflow.html

<script type="text/javascript"> 
$(document).ready(function(){
    jQuery("#list2").jqGrid({
        url:''http://tables.googlelabs.com/api/query?sql=SELECT * FROM 333136 LIMIT 10&jsonCallback=?'',
        datatype: "json",
        colModel:[
            {name:''ident'',index:''ident'',label:''ident'', width:55},
            {name:''date'',index:''date'',label:''date'', width:90},
            {name:''sourceId'',index:''sourceId'',label:''sourceId'', width:100},
            {name:''source'',index:''source'',label:''source'', width:80},
            {name:''tags'',index:''tags'',label:''tags'', width:200}      
        ],
        jsonReader: {
            repeatitems: false,
            root: function (obj) { 
                var rows = new Array();
                for(var i = 0; i < obj.table.rows.length;i++)
                {
                    var row = new Object();
                    row.id = obj.table.rows[i][0];
                    row.cell = obj.table.rows[i];
                    rows[i] = row;
                }
                return rows;
            },
            page: function (obj) { return 1; },
            total: function (obj) { return 1; },
            records: function (obj) { return obj.table.rows.length; }
        },
        rowNum:10,
        rowList:[10,20,30],
        pager: ''#pager2'',
        sortname: ''id'',
        viewrecords: true,
        sortorder: "desc",
        caption:"JSON Example"
    });
    jQuery("#list2").jqGrid(''navGrid'',''#pager2'',{edit:false,add:false,del:false});
});
</script> 

He intentado varias cosas para que funcione. Nada parece hacerlo.

Answer 1

Encuentro la pregunta muy interesante. Así que modifiqué un poco su código y funciona ahora. Puedes ver los resultados en vivo aquí .

El código JavaScript correspondiente está siguiendo

jQuery(document).ready(function() {
    jQuery("#list2").jqGrid({
        url: ''http://tables.googlelabs.com/api/query?sql='' +
                encodeURI(''SELECT * FROM 333136 LIMIT 10'') + ''&jsonCallback=?'',
        postData: "",     // don''t send any typical jqGrid parameters
        datatype: "json", // or "jsonp"
        colModel:[
            {name:''ident'',index:''ident'',key:true,width:60,sorttype:''int''},
            {name:''date'',index:''date'', width:130},
            {name:''sourceId'',index:''sourceId'',width:80,sorttype:''int''},
            {name:''source'',index:''source'',width:150},
            {name:''tags'',label:''tags'',width:350}      
        ],
        jsonReader: {
            cell: "", // the same as  cell: function (obj) { return obj; }
            root: "table.rows",
            page: function (obj) { return 1; },
            total: function (obj) { return 1; },
            records: function (obj) { return obj.table.rows.length; }
        },
        rowNum:10,
        rowList:[10,20,30],
        pager: ''#pager2'',
        sortname: ''id'',
        sortorder: "desc",
        viewrecords: true,
        loadonce: true,
        height: "100%",
        caption: "How to query Google Fusion Tables"
    });
    jQuery("#list2").jqGrid(''navGrid'',''#pager2'',{edit:false,add:false,del:false});
});