[ajayetw2009Participant]

Please suggest Sir.
Thanks in advance.

[ajayetw2009Participant]

Hi Hristo,

I have alredy Implements these as You suggest me tutorial’s link and custom sorting without grouping also working and Custom groping also working without Sorting.

Actually , in jqxgrid we have implemented server side grouping that means when we group
with any column in jqxgrid we hit servce and get data according to page size and bind the grid.

We have implemneted sorting also in server side that means when we sort with any column in jqxgrid we get
the data from database after sorting by partcular column from database and bind the grid according to page size.

So the question is :-

1:-when we group by any column in jqxgrid we get the data from server and bind the grid.
For every group lets suppose there are 10 groups created we get only one row to bind the groups .

2:- Now when we expand any group then again we hit server to get the data for that particular group which we are going to expand
After getting the data we add the rows to that particular group and expand that group.

3:- Now the requirement is to sort the expanded group , when we click on sorting in any column we again hit server to get the data in sorted manner from database
and bind the grid again with maintaing previous states .
But when we click on sorting the gropus are reordered , please guide us how to achieve this.

[ajayetw2009Participant]

Hi Hristo,

For Case 2)– If first apply multiple sort and Then apply operation grouping.I am sending you link-

https://jsfiddle.net/ajayetw2009/x0sj7vtz/31/ so you can check and this will demonstrate Case 2 with Example.

Thanks And Regards,
Ajay K.

[ajayetw2009Participant]

please suggest.

[ajayetw2009Participant]

Hi Sir ,

After using both “array” or “local” but Beforeprocessing is not working.

[ajayetw2009Participant]

Hi Sir,

when i upgrade latest jqx files it can support old one.

[ajayetw2009Participant]

Hi Sir,

please provide me solution

Thanks with Regards,

Ajay k

[ajayetw2009Participant]

Hi Sir,

There is no topic exists in this location..

plz help ..

Thanks with regards,

Ajay Kumar

[ajayetw2009Participant]

Hi Sir,

please help me……

Thanks with regards,

Ajay Kumar

[ajayetw2009Participant]

Thanks sir for giving solution.

[ajayetw2009Participant]

/
Thanks sir for reply

Its not working for this.

/ Create jqxGrid
$(“#jqxgrid”).jqxGrid(
{
width: ‘100%’,
autoheight: true,
altrows: true,
source: dataAdapter,
pagesize: 20,
pageable: true,
filterable: true,
groupable: true,
enabletooltips: true,
autoshowfiltericon: true,
columnsreorder: true,
pagesizeoptions: [’10’, ’20’, ’50’, ‘100’],
columnsresize: true,
sortable: true,
scrollmode: ‘none’,
editable: true,
selectionmode: ‘single’,
columns: [
{
text: ”, datafield: ‘IS_DELETED’, columntype: ‘checkbox’, width: ‘4%’, autoshowcolumnsmenubutton: false, filterable: false, sortable: false, menu: false, groupable: false,
renderer: function () {
return ‘

‘;
},
rendered: function (element) {
$(element).jqxCheckBox({ width: 30, height: 16, animationShowDelay: 0, animationHideDelay: 0 });
columnCheckBox = $(element);
$(element).bind(‘change’, function (event) {
var rowscount;
var checked = event.args.checked;
var paginginformation = $(“#jqxgrid”).jqxGrid(‘getpaginginformation’);
var pagenum = paginginformation.pagenum;
var pagesize = paginginformation.pagesize;
var pagescount = paginginformation.pagescount;
var pageArray = new Array();
var k = 1;
var IndexesArray = new Array();
// var rowscount = $(“#jqxgrid”).jqxGrid(‘getrows’).length;
// var rowscount = pagesize;
var rowscount1 = $(“#jqxgrid”).jqxGrid(‘getrows’).length;
if (rowscount1 < pagesize) {
rowscount = rowscount1;
}
else {
rowscount = pagesize;
}

for (var l = 0; l 0) {
GetCkeckAllData(l);
}

};
for (var i = 0; i = pagenum * pagesize && IndexesArray[i].visible 0) {
$(‘#action_Item1’).attr(‘style’, ‘display:Block’);
$(‘#div_action_Item1’).attr(‘style’, ‘display:Block’);
$(‘#action_Item’).attr(‘style’, ‘display:Block’);
$(‘#div_action_Item’).attr(‘style’, ‘display:Block’);

}
else {
$(‘#action_Item1’).attr(‘style’, ‘display:none’);
$(‘#div_action_Item1’).attr(‘style’, ‘display:none’);
$(‘#action_Item’).attr(‘style’, ‘display:none’);
$(‘#div_action_Item’).attr(‘style’, ‘display:none’);
$(‘#actionItem’).attr(‘style’, ‘display:none’);
$(‘#errorControl’).attr(‘style’, ‘display:none’);
objectArray = [];
objectArrayForDeleteRid = [];
objectArrayForLock = [];
objectarrayForUnlock = [];
arrForclickPAR_FLDR_RID = [];
arrForclickFile_Sz=[];
}
if (checked == null || updatingCheckState) return;

var rowscount = $(“#jqxgrid”).jqxGrid(‘getdatainformation’).rowscount;
$(“#jqxgrid”).jqxGrid(‘beginupdate’);
if (checked) {
$(“#jqxgrid”).jqxGrid({ selectedrowindexes: pageArray });
}
else if (checked == false) {

$(“#jqxgrid”).jqxGrid(‘clearselection’);

}
// $(“#jqxgrid”).bind(“pagechanged”, function (event) {
// for (var r = 0; r = pagenum * pagesize && IndexesArray[r].visible < (pagenum + 1) * pagesize) {
// var value = $("#jqxgrid").jqxGrid('getcellvalue', IndexesArray[r].bound, 'IS_DELETED');
// if (value != null) {
// $("#jqxgrid").jqxGrid({ selectedrowindex: IndexesArray[r].bound });
// } else {
// $('#jqxgrid').jqxGrid('unselectrow', IndexesArray[r].bound);
// };
// };
// };
// });
$("#jqxgrid").jqxGrid('endupdate');

});
}
},

{ text: 'Type', datafield: 'IconText', width: '4%', editable: false, cellsrenderer: IconRender, filterable: false },
{ text: 'RID', datafield: 'OBJ_RID', width: '6%', cellsrenderer: linkrenderer, editable: false, groupable: false },
{ text: 'Identifier', datafield: 'ID_NMBR', width: '8%', editable: false, cellsrenderer: LifeCycleRender },
{ text: 'Version', datafield: 'OBJ_VER', width: '5%', editable: false, cellsrenderer: versionlinkrenderer },
{ text: 'Change Info', datafield: 'CHG_INFO', width: '7%', editable: false, cellsrenderer: LifeCycleRender },
{ text: 'Title', datafield: 'TYT_1', width: '18%', editable: false, cellsrenderer: LifeCycleRender },
{ text: 'Status', datafield: 'STS_COD', width: '5%', editable: false, cellsrenderer: LifeCycleRender },
{ text: 'Lifecycle State', datafield: 'STT_NM', width: '6%', editable: false, cellsrenderer: LifeCycleRender },
{ text: 'Category', datafield: 'CLS_LBL', width: '8%', editable: false, cellsrenderer: LifeCycleRender },
//{ text: 'Effective Timestamp', datafield: 'EFF_TS', width: '10%', editable: false, formatstring: "ddd" },
{text: 'Modified By', datafield: 'MBY_NM', width: '6%', editable: false, cellsrenderer: LifeCycleRender },
{ text: 'Last Modified Date & Time (UTC)', datafield: 'MBY_TS', width: '10%', editable: false, cellsrenderer: LifeCycleRender, formatstring: "ddd" },
{ text: 'Locked By', datafield: 'OWNR_NM', width: '6%', editable: false, cellsrenderer: LifeCycleRender },
{ text: 'Menu', datafield: 'Menu', width: '7%', editable: false, cellsrenderer: MenuRender, filterable: false, sortable: false, groupable: false, menu: false },
{ text: 'Share', datafield: 'Share', width: '7%', editable: false, cellsrenderer: ShareRender, filterable: false, sortable: false, groupable: false, Share: false }
]
});

GetCheckBoxStaus();

}

[Author]

Posts