jqGrid在分组时对列进行排序考虑分组标题 [英] jqGrid sorting a column while grouping consider grouping header
本文介绍了jqGrid在分组时对列进行排序考虑分组标题的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我有 jqgrid.我根据列值对几行进行了分组.、这里和此处) 在您进行分组的列 DocGroup
上:
sorttype: function (cellvalue, rowObject) {返回单元格值?单元格值:rowObject.Documents;}
结果,具有空 DocGroup
的输入数据将按 Documents
进行排序和分组.您将在 Fiddle
I have jqgrid. I've grouped few rows based on a column value. Working demo is available at link part of the code that defines jqGrid
var preclosingtable = $('#preclosing');
preclosingtable.jqGrid({
datatype: 'local',
data: data.DOCS,
colNames: ['', 'Documents Received', 'Comments', 'NA', 'DocGroup'],
colModel: [
{ name: 'Documents', index: 'Documents', align: 'left', sortable: false, editable: false, width: 20 },
{ name: 'DocsReceived', index: 'DocsReceived', align: 'center', sortable: false, editable: true, edittype: 'checkbox', editoptions: { value: "True:False" }, formatter: "checkbox", width: 140 },
{ name: 'Comments', index: 'Comments', align: 'center', sortable: false, editable: true, edittype: "textarea", editoptions: { rows: "3", cols: "16" }, width: 180 },
{ name: 'NA', index: 'NA', editable: true, formatter: 'dynamicText', width: 150, edittype: 'custom', editoptions: { custom_element: radioelem, custom_value: radiovalue} },
{ name: 'DocGroup', index: 'DocGroup', editable: false, width: 1 }
],
rowNum: data.DOCS.length,
//rowList: [10, 20, 30],
pager: '#preclosingpagerdiv',
viewrecords: true,
sortorder: "asc",
sortname: 'Documents',
grouping: true,
groupingView: {
groupField: ['DocGroup'],
groupColumnShow: [false],
groupDataSorted: true,
groupOrder : 'asc'
},
localReader: {
id: 'ConfigId'
},
shrinkToFit: false,
height: 'auto',
loadComplete: function () {
HideGroupHeaders(this);
},
onSelectRow: function (id) {
preclosingtable.jqGrid('saveRow', previouslyselectedRow, false, 'clientArray');
previouslyselectedRow = SetJQGridRowEdit(id, previouslyselectedRow, preclosingtable);
}
});
Following is how my grid looks like
Issue: Is it possible to sort rows in this grid so that the final grid has rows in the following Order
- Alabama
- D
- Maine
- NewJersey
- Q
- Virginia
解决方案
If I correctly understand your problem you can solve your problem by adding custom sorting function (see here, here and here) on the column DocGroup
where you do the grouping:
sorttype: function (cellvalue, rowObject) {
return cellvalue? cellvalue : rowObject.Documents;
}
As the result the input data which have empty DocGroup
will be sorted and so grouped by Documents
. You will see the results on Fiddle
这篇关于jqGrid在分组时对列进行排序考虑分组标题的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文