Messages

1

Help for ParamQuery Grid (free version) / Re: How to set checkboxes outside the viewport when using virtualX/virtualY?

« on: June 12, 2023, 02:24:13 pm »

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

2

Help for ParamQuery Grid (free version) / Re: How to set checkboxes outside the viewport when using virtualX/virtualY?

« on: May 29, 2023, 09:02:44 pm »

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

3

Help for ParamQuery Grid (free version) / Re: How to set checkboxes outside the viewport when using virtualX/virtualY?

« on: May 26, 2023, 06:28:21 pm »

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.

4

Help for ParamQuery Grid (free version) / Re: How to set checkboxes outside the viewport when using virtualX/virtualY?

« on: May 24, 2023, 02:07:33 am »

Awesome! I will give this a try.

5

Help for ParamQuery Grid (free version) / How to set checkboxes outside the viewport when using virtualX/virtualY?

« on: May 22, 2023, 02:15:58 am »

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?