Why do you use addJsonData? Just set the url and the grid will do the rest for you.

Not sure, but please try not to use SECTOR/REGION - if possible rename this in colModel and DATA with

SECTOR_REGION or something elese.

 

Regards

 

Thank you for the suggestion. For first option , I tried putting for loop before using jqgrid function , but I m getting error 

...!1),this.each(function(){var X=f.length;n=!0===this.p.rownumbers?1:0;h=!0===this...

in jquery.jqGrid.min.js on line no 149 !! 

Second option is not clear to me  

Even i went through few examples , but could not get an idea on dynamic grouping. Can you please suggest on this?

Thanks a lot,

Shraddha

 

EDIT: Hi Tony,

 

Now I removed addRowData from the code and using addJSONData. With this, its grouping the data only at first level but till limited rows. Following is the code :

showJQgrid :function(sysObj)
{

var Jsj = sysObj.filteredData;
$('#grid').jqGrid({
datatype : 'json',
colNames:['MARKET','SECTOR/REGION','PRODUCT','DATE', 'LAST-CLOSED', 'VOLUME'],
colModel:[
{name:'MARKET',index:'MARKET', width:100},
{name:'SECTOR/REGION',index:'SECTOR/REGION', width:100},
{name:'PRODUCT',index:'PRODUCT', width:150},
{name:'DATE',index:'DATE', width:85, sorttype:"date", formatter:"date"},
{name:'LAST-CLOSED',index:'LAST-CLOSED', width:100, sorttype:"float",formatter:"number",editable:true},
{name:'VOLUME',index:'VOLUME', width:100, align:"right",sorttype:"float", formatter:"number", editable:true},
],

pager : '#pager',
rowNum:20,
rowList : [10, 30, 50 ],
viewrecords : true,
gridView:true,
grouping:true,
groupingView : {
groupField: ['MARKET','SECTOR/REGION'],
groupColumnShow: [true,true],
groupCollapse: true,
},
});

jQuery("#grid")[0].addJSONData(Jsj);
$("#grid").trigger('reloadGrid');

$("#grid").jqGrid('navGrid',"#pager", {edit : false,add : false,del : false});

 

In all cases this will not work.

When using addRowdata the grouping will not work.

You have 2 options

 

1. After add a datawith addrowdata make the grouping - just see the doks and demos (dynamic grouping)

2. Use data parameter to passs the dataand set the key property - again see docs

 

Regards

I am using jqgrid and trying to group columns. But somehow its not grouping the data . Following is the code I am using.Please advise.

showJQgrid :function(sysObj)

{
console.log("inside showJQGrid");
var Jsj = sysObj.filteredData;
$('#grid').jqGrid({
datatype : 'json',
colNames:['MARKET','SECTOR/REGION','PRODUCT','DATE', 'LAST-CLOSED', 'VOLUME'],
colModel:[
{name:'MARKET',index:'MARKET', width:80},
{name:'SECTOR/REGION',index:'SECTOR/REGION', width:100},
{name:'PRODUCT',index:'PRODUCT', width:150},
{name:'DATE',index:'DATE', width:85, sorttype:"date", formatter:"date"},
{name:'LAST-CLOSED',index:'LAST-CLOSED', width:85, sorttype:"float",formatter:"number",editable:true},
{name:'VOLUME',index:'VOLUME', width:100, align:"right",sorttype:"float", formatter:"number", editable:true},
],

pager : '#pager',
rowList : [10, 20, 30 ],
viewrecords : true,
grouping:true,
groupingView : {
groupField: ['MARKET','SECTOR/REGION'],
groupColumnShow: [false,false],
groupCollapse: true,
groupOrder: ['asc']
},
});
for ( var i = 0; i < Jsj.length; i++)
{
jQuery("#grid").jqGrid('addRowData', i+1, Jsj[i]);
$("#grid").trigger('reloadGrid');

}

$("#grid").jqGrid('setGridHeight', $("#center").height());
$("#grid").navGrid("#pager", {
edit : false,
add : false,
del : false
});

$("#grid").jqGrid('inlineNav', "#pager");

}

 

Thanks,

Shrads