jQuery Grid Plugin - jqGrid - Topic: subgrid is not displaying the data it gets. http://www.trirand.com/blog/?page_id=393/help/subgrid-is-not-displaying-the-data-it-gets Simple:Press Version 5.7.5.3 tedbyers on subgrid is not displaying the data it gets. http://www.trirand.com/blog/?page_id=393/help/subgrid-is-not-displaying-the-data-it-gets#p27928 Help http://www.trirand.com/blog/?page_id=393/help/subgrid-is-not-displaying-the-data-it-gets#p27928 jqgrid is quickly becoming one of my favourite grids, but, sometimes I have a little trouble.  Here is how my latest grid is created:

$(function() {

$( "#transhist" ).jqGrid({
url:'/cgi-bin/transaction.history.pl?tid=93e9113ad026a226f3f2dea0afdc6f9e05dc3933authREITUMU',
datatype: 'xml',
mtype: 'GET',
colNames:['Transaction Id','Date', 'Transaction Type', 'Transaction result', 'Amount'],
colModel :[
{name:'transaction_id',index:'transaction_id',width:120},
{name:'transaction_date',index:'transaction_date',width:180,align:'center'},
{name:'action_type',index:'action_type',width:120},
{name:'success',index:'success',width:100,align:'center'},
{name:'amount',index:'amount',width:80,align:'right'},
],
pager: '#transpager',
altRows: true,
rowNum:15,
rowList:[15,30,45],
sortname: 'transaction_date',
sortorder: 'desc',
pgbuttons: true,
gridview: true,
width: 950,
height: 400,
onSelectRow: function (id) {
var grid = jQuery('#transhist');
var sel_id = grid.jqGrid('getGridParam', 'selrow');
var cont = grid.getCell(sel_id, 'transaction_id');
window.open('https://secure.profitorius.com/cgi-bin/transaction.details.report.pl?tid=' + cont);
},
multiselect: false,
subGrid : true,
subGridUrl: '/cgi-bin/transaction.history.subgrid.pl',
subGridModel: [{ name : ['Transaction Id','Date', 'Transaction Type', 'Transaction result', 'Amount'],
width : [120,180,120,100,80]}],
caption: 'Basic Transaction Data'
});
});

This displays OK, unless I try to get the subgrid for one of my transactions.  Then, I get only the subgrid's column titles and no data.  This is expected for most transactions, as few have multiple trnsactions.  However, here is a sample of the XML my perl CGI script produces.

<?xml version='1.0' encoding='latin1'?>

<rows>

<row>

<cell>1a294c474ef117d52b1dd3aba0b60f34606d822ccapRITUMI</cell>

<cell>2012-12-11 15:50:07</cell><cell>capture</cell><cell>1</cell>

<cell>15.00</cell>

</row>

</rows>

Yet, even with this XML, I get only the subgrid's column headers and no data.

This is the last bit of the puzzle for this particular page.  All else is working flawlessly, including making use of our customized jQuery CSS files.

How do I get jqgrid's subgrid to actually display the data when there is data?  Or, equally likely; what mistake did I make in setting up this subgrid?

Thanks

Ted

]]> Tue, 18 Dec 2012 04:32:34 +0200