How to set checkboxes outside the viewport when using virtualX/virtualY?

[omeroon]

Hi there!

I am building a large grid (=20000 records or more with 20-30 columns): it is 5 columns with filterable data and then 20-25 columns of checkboxes.
I have made a simple toggle function that will allow the user to make a selection and then toggle all checkboxes in the selection with the rightMousebutton.

Code: [Select]

let selectionArr =  myGrid.pqGrid( "selection",
   type: 'cell', method: 'getSelection' }
);

for (var i = 0; i < selectionArr.length; i++) {
   let value = myGrid.pqGrid(  "getCell", { rowIndx: selectionArr[i].rowIndx, dataIndx: selectionArr[i].dataIndx, refresh: true } );
   $(value[0]).find('input').trigger('click');
}


This works very well, however only on the items within the viewport as I am using virtualX and virtualY (without it it becomes too slow). The selection outside of the viewport is still selected, but none of the checkboxes are rendered in virtualX/virtualY so they can't be clicked. I had hoped I could get the data using something like:

Code: [Select]

myGrid.pqGrid( "data", {rowIndx: selectionArr[1].rowIndx} ).data;

But that seems to be empty.

What would be the best solution for this?

[paramvir]

you can get the corresponding row data to set the value of fields bound to checkboxes.

https://paramquery.com/api#method-getRowData

Code: [Select]

var rowData = myGrid.pqGrid( "getRowData", {rowIndxPage: 2} );
rowData[ dataIndx of checkbox ] = value;

And refresh the grid after setting checkbox values:

Code: [Select]

myGrid.pqGrid( "refresh" );


[omeroon]

Awesome! I will give this a try.

[omeroon]

Worked perfectly!!!

To help somebody else here is what I did: using

Code: [Select]

myGrid.pqGrid( "getColModel" ) I extracted the names of the columns and the values of cb.check and put this in an array.

So something like:

Code: [Select]

colModelArray["colA" => 18, "colB" => 24, "colC" => 33]
Using the code of Paramvir I can now get the rowData of my selection even if the fields are outside the viewport, and I then alter the values based on the dataIndx which is the same as the key of the colModelArray.

[omeroon]

@paramvir: is there a way to add these changes to the history as well so I can get undo/redo to work?

[omeroon]

Anyone? Would be nice to get the undo/redo options working.