jQuery Grid Plugin - jqGrid - Topic: userdata, how to access it in useful ways?

chrisisbd on userdata, how to access it in useful ways?

Mon, 30 Jan 2012 19:54:18 +0200

OK, I finally got there!

My code is now:-

$(function(){
$("#t2").jqGrid({
    url:'getData.php?urn=sqlite:////var/www/wiki/data/meta/money.db&table=jessica',
    datatype: 'xml',
    mtype: 'GET',
    colNames:['id','Date', 'Description','Credit', 'Debit'],
    colModel :[
      {name:'id', index:'id', width:20, editable: true},
      {name:'Date', index:'Date', width:50, editable: true},
      {name:'Description', index:'Description', width:500, align:'right', editable: true},
      {name:'Credit', index:'Credit', width:80, align:'right', editable: true},
      {name:'Debit', index:'Debit', width:80, align:'right', editable: true}
    ],
    pager: '#pager',
    rowNum:10,
    rowList:[10,20,30],
    sortname: 'id',
    sortorder: 'asc',
    viewrecords: true,
    gridview: true,
    caption: "Caption",
    cellEdit: true,
    userDataOnFooter: true,
    footerrow: true,
    loadComplete: function (x) {
        var z = ""
        var x = jQuery("#t2").jqGrid('getGridParam', 'userData')['Debit'];
        alert(x);
    }
});
});

... and I get to see my data in the alert box. I think my problem before was simply that I was trying to get at the userdata before the grid had been instantiated. The documentation doesn't help at all on this, I had the syntax of getGridParam correct but was calling it before there was any data to access.

I think there needs to be a full example using loadComplete (or something else) to show how to actually get some userdata by name and do something with it.

tony on userdata, how to access it in useful ways?

Mon, 30 Jan 2012 18:23:45 +0200

Well,

You refer to the documenation, but it seems you do not read it carefully.

Your calling convention is wrong.

Please refer here

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

Read to the end please

Regards

chrisisbd on userdata, how to access it in useful ways?

Mon, 30 Jan 2012 16:59:40 +0200

I have the following code

$(function(){
var x = "userData is: " + $("#t2").jqGrid.getGridParam('userData');
$("#t2").jqGrid({
    url:'getData.php?urn=sqlite:////var/www/wiki/data/meta/money.db&table=jessica',
    datatype: 'xml',
    mtype: 'GET',
    colNames:['id','Date', 'Description','Credit', 'Debit'],
    colModel :[
      {name:'id', index:'id', width:20, editable: true},
      {name:'Date', index:'Date', width:50, editable: true},
      {name:'Description', index:'Description', width:500, align:'right', editable: true},
      {name:'Credit', index:'Credit', width:80, align:'right', editable: true},
      {name:'Debit', index:'Debit', width:80, align:'right', editable: true}
    ],
    pager: '#pager',
    rowNum:10,
    rowList:[10,20,30],
    sortname: 'id',
    sortorder: 'asc',
    viewrecords: true,
    gridview: true,
    caption: x,
    cellEdit: true,
    userDataOnFooter: true,
    footerrow: true
});
});
</script>

</head>
<body>
<H3><script>var msg="Hello everyone";document.write(msg);</script></H3>

<table id="t2"><tr><td/></tr></table>
<div id="pager"></div>
<table id="t3"><tr><td/></tr></table>

The userdata *is* being sent because I see it in the footer. However I can't see *any* other way to access it, I've tried $("#$("#t2").jqGrid.getGridParam('userData'); and $("#t2").getGridParam('userData'); both always return undefined. There seems no actual way to get at the userdata in a form that can actually be used.

While I'm about it the documentation refers to the 'options' array, is this an actual, accessible, array or is it just a way of describing things?