Guriddo » Topic: Jqgrid not grouping columns with json data

Jqgrid not grouping columns with json data

Guriddo
Jqgrid not grouping columns with json data

This topic has 7 replies, 4 voices, and was last updated 10 years, 3 months ago by guriddo.support.

Creator

Topic
September 5, 2014 at 8:40 pm #81793

shrads
Participant

Hi,

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:,
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: ,
groupColumnShow: [false,false],
groupCollapse: true,
groupOrder:
},
});
for ( var i = 0; i < Jsj.length; i++)
{
jQuery(“#grid”).jqGrid(‘addRowData’, i+1, Jsj);
$(“#grid”).trigger(‘reloadGrid’);

}

$(“#grid”).jqGrid(‘setGridHeight’, $(“#center”).height());
$(“#grid”).navGrid(“#pager”, {
edit : false,
add : false,
del : false
});

$(“#grid”).jqGrid(‘inlineNav’, “#pager”);

}

Â

Thanks,

Shrads
Creator

Topic

Viewing 7 replies - 1 through 7 (of 7 total)

Author

Replies

September 8, 2014 at 2:09 pm #102230

tony

Keymaster

Hello,

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

September 15, 2014 at 7:21 pm #102272

shrads

Participant

Hi Tony,

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...

1	...!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:,
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: ,
groupColumnShow: [true,true],
groupCollapse: true,
},
});

jQuery(“#grid”)[0].addJSONData(Jsj);
$(“#grid”).trigger(‘reloadGrid’);

$(“#grid”).jqGrid(‘navGrid’,”#pager”, {edit : false,add : false,del : false});

September 17, 2014 at 10:00 am #102278

tony

Keymaster

Hello,

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

January 13, 2016 at 10:00 am #124673

hope4555

Participant

This is still not working for me

Example data:

{“rows”:[
{“Id”:1,”Enabled”:true,”Encrypted”:false,”Guid”:”39d30724-eef0-427f-8e92-a7d0ca4181b2″,”Name”:”Jerusalem”,”Description”:null,”Config”:null,”Type”:”weather”},
{“Id”:2,”Enabled”:true,”Encrypted”:false,”Guid”:”66c099a7-743d-47e4-9b66-a48a4b1ca6bb”,”Name”:”New York”,”Description”:null,”Config”:null,”Type”:”weather”},
{“Id”:3,”Enabled”:false,”Encrypted”:false,”Guid”:”76dd1781-9e49-473f-8436-527d02208fc3″,”Name”:”Recent Media”,”Description”:null,”Config”:null,”Type”:”instagram”},
{“Id”:4,”Enabled”:true,”Encrypted”:true,”Guid”:”a65a376f-6a0c-4b90-90cc-fa940131ce84″,”Name”:”Exchange”,”Description”:”Exchange Collector”,”Config”:null,”Type”:”exchange”},
{“Id”:5,”Enabled”:true,”Encrypted”:false,”Guid”:”53795660-ef3e-400d-95be-a3efb480ed04″,”Name”:”fff”,”Description”:”fff”,”Config”:null,”Type”:”weather”}
]
}

try to group by Type and i get “<b>weather” group twice</b>

January 13, 2016 at 2:16 pm #124675

guriddo.support

Participant

Hello,

You will need to sort the data by Type, before to use it in grouping. As of version 4.6 or 4.5 (I can not remember exact) the data should be sorted.

Your data is not sorted.

Kind Regards,

Will

Guriddo Support Team

January 13, 2016 at 2:21 pm #124676

hope4555

Participant

I see

Thank you

Other thing with grouping, after i sort the data, not all the rows are selectable

i can select only one row per- group

So if i have 3 items in a group, i can select only the lower one.

If this something that i have to configure?

January 13, 2016 at 5:33 pm #124680

guriddo.support

Participant

Hello,

This is not desired action. If you look into the demo you will see that all the rows in the grouping are select able.

Please provide a grid setup or send us a link to the problem (jsfiddle or other)

Jqgrid not grouping columns with json data

Search Forum

Recent Replies

Forum Statistics

UserOnline