jQuery Grid Plugin - jqGrid - Topic: Get total rows before grid is rendered

RustedBucket on Get total rows before grid is rendered

Wed, 14 Dec 2011 16:23:56 +0200

Ok think I got it figured out… Here's the modified code of the above…

    $.ajax({
        type: "POST",
        url: "/air/purchases/detailgrid/ponum/" + postData,
        datatype: "json",
        success: function (data, status) {
            var tdata = JSON.stringify(data);
            var trows = data.records;
            renderGrid(trows, tdata);
        }
   });

   function renderGrid(trows, tdata) {

        jQuery("#purchases").jqGrid({

            datatype: "jsonstring",
            datastr: tdata,

…

Basically needed to convert the JSON object to a string and pass the whole thing to the grid, then tell the grid to use a JSON string. Works like a champ now.

RustedBucket on Get total rows before grid is rendered

Wed, 14 Dec 2011 03:39:35 +0200

Tony, ok I got it sort of figured. Here's my code.

$.ajax({
    type: "POST",
    url: "/air/purchases/detailgrid/ponum/" + postData,
    datatype: "json",
    success: function (data, status) {
        var tdata = data.rows;
        var trows = data.records;
        renderGrid(trows, tdata);
    }

});

function renderGrid(trows, tdata) {
jQuery("#purchases").jqGrid({

        datatype: "local",
        data: tdata,
          height:theight,
          colNames:['Item', 'UPC', 'Description', 'Order Qty.', 'Est. Cost', 'Shipped Qty.', 'Billed Cost'],
          colModel:[
              {name:'item_number',index:'item_number', width:20, align:"center"},
              {name:'upc',index:'upc', width:20, align:"center"},
              {name:'description',index:'description', width:55},
              {name:'order_quantity',index:'order_quantity', width:15, align:"center",formatter: 'integer', formatoptions:{thousandsSeparator: ",", defaultValue: '0'}},
              {name:'order_unit_cost',index:'order_unit_cost', width:15, align:"center",formatter: 'currency', formatoptions:{decimalSeparator:".", thousandsSeparator: ",", decimalPlaces: 2, prefix: "$ "}},
              {name:'shipped_quantity',index:'shipped_quantity', width:15, align:"center",formatter: 'integer', formatoptions:{thousandsSeparator: ",", defaultValue: '0'}},
              {name:'shipped_unit_cost',index:'shipped_unit_cost', width:15, align:"center",formatter: 'currency', formatoptions:{decimalSeparator:".", thousandsSeparator: ",", decimalPlaces: 2, prefix: "$ "}}
          ],
          rowNum: trows,
          rownumbers: true,
          rownumWidth: 40,
          pager: '#pager',
          altRows: true,
          altclass:'myAltRowClass',
          gridview: true,
        viewrecords: true,
        footerrow: true,
        userDataOnFooter: true,
        sortorder: "asc",
        autowidth: true,
        shrinkToFit: true

   });
}

The problem now is, the grid display with the correct number of rows, and the JSON data is there in Firebug but all the rows are empty. Any ideas what I'm doing wrong?Thanks

RustedBucket on Get total rows before grid is rendered

Tue, 13 Dec 2011 19:38:17 +0200

Figured out the beforeProcessing issue. Wasn't using the latest 4.3 version of the grid which contained the beforeProcessing functions.

I thought this might work but it doesn't.

    beforeProcessing: function(t,data, status, xhr) {
       jQuery.extend(jQuery.jgrid.defaults, { rowNum:t.records });
   },

RustedBucket on Get total rows before grid is rendered

Tue, 13 Dec 2011 18:09:24 +0200

Mostly because everything I've tried so far hasn't worked. You mind giving an example.

I would have assumed according to the doc that beforeProcessing would be a trigger point to do this, but that seems to do nothing at all.

I'd prefer not to call the query a second time just to get something that's already being returned to the grid, I just can't seem to figure out where/how to read it.

tony on Get total rows before grid is rendered

Tue, 13 Dec 2011 09:27:39 +0200

Hello,

I wonder why do you try to resolve everthing with the grid methods. You should have a very simple solution.

Create your own ajax call - this call should ask for the number of recordes (separate one)

In the succes of this ajax call construct your grid with the rowNum obtained from the request.

Regards

Tony

RustedBucket on Get total rows before grid is rendered

Mon, 12 Dec 2011 23:19:15 +0200

Is there a way to get the total rows and set rowNum before the grid is actually rendered? Picking an arbitrary number like 100 is fine for queries returning less than 100 records, but once those go over the rowNum limit no more records are displayed (without paging or dynamic scrolling etc).

The JSON response contains the total number of records contained in the results set, is there a way to read this and use that value to set rowNum so the grid can always display the total number of records without hitting a hard limit?