jQuery Grid Plugin - jqGrid - Topic: JSON data as array of arrays? http://www.trirand.com/blog/?page_id=393/help/json-data-as-array-of-arrays Simple:Press Version 5.7.5.3 tony on JSON data as array of arrays? http://www.trirand.com/blog/?page_id=393/help/json-data-as-array-of-arrays#p11112 Help http://www.trirand.com/blog/?page_id=393/help/json-data-as-array-of-arrays#p11112 Hello,

Read to the end.

http://www.trirand.com/jqgridw.....t_notation

Regards

Tony

]]> Tue, 27 Oct 2009 03:04:10 +0200 Dave on JSON data as array of arrays? http://www.trirand.com/blog/?page_id=393/help/json-data-as-array-of-arrays#p11008 Help http://www.trirand.com/blog/?page_id=393/help/json-data-as-array-of-arrays#p11008 Thanks, John...

I'm still having trouble with this, though.  The example shows data arranged in an array of unnamed objects, not an array of arrays.

I tried setting cell:"" in the jsonReader, but it's still not getting the data to display.  What should I have for the colModel ?  This is what I have so far:

    colModel :[
      {name:'from_campaign_name', width:300},
      {name:'to_campaign_name',  width:300},
      {name:'transfer_count', width:100}
       ],
    pager: jQuery('#pager'),
    rowNum:10,
    rowList:[10,20,30],
    sortname: '',
    sortorder: "",
    viewrecords: true,
    imgpath: 'themes/basic/images',
    caption: 'My first grid',
    jsonReader : {
       root: "results",
       page: "",
       total: "",
       records: "",
       repeatitems: true,
       cell: ""
       }
 

I get the table header and footer, but no data.

Thanks,

Dave

]]> Thu, 22 Oct 2009 23:10:46 +0300 John on JSON data as array of arrays? http://www.trirand.com/blog/?page_id=393/help/json-data-as-array-of-arrays#p10993 Help http://www.trirand.com/blog/?page_id=393/help/json-data-as-array-of-arrays#p10993 Not directly, but you can use jsonReader to match up your returned data to the data expected by the grid. See /jqgridwiki/doku.php?id=wiki:retrieving_data#json_data

]]> Thu, 22 Oct 2009 12:25:32 +0300 Dave on JSON data as array of arrays? http://www.trirand.com/blog/?page_id=393/help/json-data-as-array-of-arrays#p10991 Help http://www.trirand.com/blog/?page_id=393/help/json-data-as-array-of-arrays#p10991 Hi....

Is it possible to directly use JSON data returned from the server in the following format:

  { "reportObject" : { "columnNames" : [ "from__campaign_name",
          "to__campaign_name",
          "transfer_count"
        ],
      "columnTypes" : [ "VARCHAR",
          "VARCHAR",
          "BIGINT"
        ],
      "createTimeStamp" : "2009-10-21 17:42:58",
      "results" : [ [ "Basic_EN_AfterHours",
            "",
            "34"
          ],
          [ "Basic_EN_CaseLU",
            "",
            "28"
          ],
          [ "Basic_EN_CaseLU",
            "Basic_EN_Greeting",
            "82"
          ],
          [ "Basic_EN_CaseLU",
            "B_Other",
            "55"
          ],

The "results" element contains all of the data for the table cells.

Thanks,

Dave

]]> Thu, 22 Oct 2009 11:59:57 +0300