jQuery Grid Plugin - jqGrid - Topic: JSON Data not Loading

tony on JSON Data not Loading

Fri, 12 Feb 2010 14:51:41 +0200

Hello,

You should configure your jsonReader for this purpose. In order to work this a repeatitems should be set to false

http://www.trirand.com/jqgridw.....#json_data

Regards

lupin on JSON Data not Loading

Fri, 12 Feb 2010 13:49:19 +0200

Ok, it's now changed to this:

{"page":"2","records":"50","rows":[{"id":"1","total":"cell1","note":"cell2"}],"total":"10"}

but still no joy, I only see loading button.

HoSpiTaL_gHoSt on JSON Data not Loading

Fri, 12 Feb 2010 13:29:45 +0200

According to your grid definition, the outcome from your URL should be the following in order to be loaded correctly into your jqGrid:

{"page":"2″,"records":"50″,"rows":[{"id":"1","total":"cell1","note":"cell2"}],"total":"10″}

lupin on JSON Data not Loading

Fri, 12 Feb 2010 13:03:44 +0200

Greetings,

The json/ouput from my url 'list' is something like this:

{"page":"2","records":"50","rows":[{"id":"1"},[{"total":"cell1","note":"cell2"}]],"total":"10"}

and the following grid definition on my html file, but I can only see the grid without data inside on it's row, what do I miss? I've been re-reading the wiki and docs.Thanks in advance.

jQuery(document).ready(function(){
jQuery("#list2").jqGrid({
        url:'/list',
        datatype: "json",
        colNames:['Inv No','Total','Notes'],
        colModel:[ {name:'id',index:'id', width:55},
                   {name:'total',index:'total', width:80,align:"right"},
                   {name:'note',index:'note', width:150, sortable:false} ],
        rowNum:10,
        rowList:[10,20,30],
        pager: '#pager2',
        sortname: 'id',
        viewrecords: true,
        sortorder: "desc",
        root: "rows",
        cell: "",
        id: "0",
        caption:"" });
jQuery("#list2").jqGrid('navGrid','#pager2',{edit:false,add:false,del:false});
});
</script>

regards,

lupin