[sairamParticipant]

Hi Dimitar ,

Please find the comments below for the above mentioned points. please provide your inputs to achive the expected behaviour .

1: its not the rendering property ,i am using the property renderer.
2: yes my requirement is to determine the state of group checkbox header based on other fields data . using the rendered column property to determine the same .
3: i tried using the cellsrenderer column property , still having the issue in applying the custom logic during the cell redering .
Observation :
In the cellsrenderer call back method (ie showdifference method ), i need to apply the css to a particular cell column , by checking the data of other 2 columns in the corresponding row to identify the applicable CSS .
while debugging , data of the columns returned were not of the corresponding row . ie when the grid is rendering the second row , i am getting the column info of first row . i am trying to implement for a grouping grid and serverside pagination, pls suggest is it due to grouping grid.

4: Using the built-in columntype: ‘checkbox’ only , since we have multiple check boxes columns headers , want to generate the unique id for each column header checkbox.

please find the updated code snippet:

$(“#jqxgrid”).jqxGrid(
{
width: 670,
source: source,
pageable: true,
autoheight: true,
columns: [
{ text: ‘First Name’, datafield: ‘firstname’, width: 100 },
{ text: ‘Last Name’, datafield: ‘firstname’, width: 100 },
{ text: ‘New Permissions’, datafield: ‘firstname’, width: 100 },
{ text: ‘Old Permissions’, datafield: ‘firstname’, width: 100 },
{ text: ‘Modified’, datafield: ‘firstname’, width: 100 },
{ text: ‘PermissionInfo’, datafield: ‘lastname’, width: 100 ,columntype: ‘checkbox’ ,
rendering:function(){ // generating uniqueID
return ‘<div > <label> viewpermission </label> <div id=”viewpermission”> </div></div>’;
} ,
rendered: function(element){ //Binding events for the geneatedID

var viewpermId = $(element).find(‘#viewpermission’);

$(viewpermId).on(‘change’,function(event){
// if this view is checked or unchecked ,
we are manipulating the other cell values

}
);

}
,cellsrenderer : showdifference
}
]
});

showdifference = function(row,columnfield,value,defaulthtml,columnproperties){
var value1 = $(‘#jqxGrid’).jqxGrid(‘getcellvalue’, row, “New Permissions”);
var value2 = $(‘#jqxGrid’).jqxGrid(‘getcellvalue’, row, “Old Permissions”);
if value1 != value2
apply different css for modfied column
// reading the properties of other comlumns to compare

return css class based on the column.
}

Thanks
sairam

[sairamParticipant]

HI Dimitar ,

We have customized check boxes in the grid and i have to manipulate other cell values based on this editable column . i have provided the code in detail below .Even noticed the other issue while applying the server side pagination . i am applying the css by using the cellclassname property , which is working fine in client side .
Could you please assist to sort out this issue ..

$(“#jqxgrid”).jqxGrid(
{
width: 670,
source: source,
pageable: true,
autoheight: true,
columns: [
{ text: ‘First Name’, datafield: ‘firstname’, width: 100 },
{ text: ‘Last Name’, datafield: ‘lastname’, width: 100 ,columntype: ‘checkbox’ ,
rendering:function(){ // generating uniqueID
return ‘<div > <label> viewpermission </label> <div id=”viewpermission”> </div></div>’;
} ,
rendered: function(element){ //Binding events for the geneatedID

var viewpermId = $(element).find(‘#viewpermission’);

$(viewpermId).on(‘change’,function(event){
// if this view is checked or unchecked ,
we are manipulating the other cell values

}
);

}
,cellclassname: applyasthetics
}
]
});

applyasthetics = function(row,column,value,data){
return css class based on the column.
}

Thanks
sairam korada

[sairamParticipant]

Hi ,
since the current data load is around 3000 records, loading the complete data to Jqx grid and performing client side sorting and filtering . when the user clicks on save button , we need to persists the changes to DataBase .
Now we want to support for more than 15000 records , so we are planning to make the pagination as serverside . Is this is suitable approach for our requirement . since this is editable grid ,if we go for server side pagination on click of next page we need to save the changes made .Ours is Banking Application and we perform lot of validations before saving the data to Database .
Rather than saving the data on next page click , do we have any best suitable approach to deal this situations .

[sairamParticipant]

Hi Peter ,

Thanks for your response . Now i change the call back method to loadComplete in the same example and tried to access the adapter in call back method . encountered with the same issue .

[Author]

Posts