Virtualmode and filter

[DeployDuckParticipant]

Hello,

We have to build grids with up to 2500 columns and expected aproximately 35.000 rows of data so we decided to use the virtualmode.
We have also to build in the filterrow.

But if we input any value in the filterfield, we get no reaction (only the row that should be filtered will become a colored background) and no filtering from the grid, not even a debug message.

Is it correct, that filters don’t work when the grid is used with virtualmode?
I can’t get find any documentation about this.

Best Regards.

[DeployDuckParticipant]

As a supplement:
We set up the grid as in your demo (virtualmode, rendergridrows, pageable used) with real data (filled with every data type: 2498 columns and 34,967 data records). There are also occasional data records with the value “zero”, if that could be decided.

What we found:
– filter does not work
– grouping works – but only ungrouped data are exported (tried with excel xlsx)
– sorting does not work

Best Regards.

[MartinParticipant]

Hello DeployDuck,

In virtual mode, the data operations are handled not by the Grid, but by the custom code written by the developer. In Virtual Mode, the Grid provides a callback function with parameters – Start Row Index and End Row Index. The result of that function is what the Grid will display. The virtual mode is usually used in Server scenarios i.e Sorting, Filtering and Paging are implemented on the Server and the Grid just displays the Data returned by the Server. You can look at the PHP Demos available on our web site. They show how to implement Filtering, Sorting and Paging when Virtual Mode is enabled.

Best Regards,
Martin

jQWidgets Team
https://www.jqwidgets.com/

[Author]

Posts