Filter row doesn't work for Grid with paging mode

[taziParticipant]

Hi,

We have an “Editable” Grid, with “filter row” and “paging mode”. This Grid have 20000rows.

Description of the problem :
——————————–
When we trying to filter a column, the result of the filter is applied only on visible current page. Or, the filter should be applied to all data of the Grid, from first page to the last page.

Question :
— how to change the “filter row” behavior to filter one/or more columns on all data in the pageable Grid?
–> Or other solution to apply filter in all grid data ?

Best regards,
Tazi

[DimitarParticipant]

Hi Tazi,

I assume you have enabled virtual mode in your grid. If that is so, the only solution is to implement server-side filtering and paging, as done in the following demo: http://www.jqwidgets.com/jquery-widgets-demo/demos/php/serverfiltering_paging_and_sorting.htm?arctic.

Best Regards,
Dimitar

jQWidgets team
http://www.jqwidgets.com/

[taziParticipant]

Hi and thanks.

No, the virtualmode = false.

because, I have an Editable Grid and the virtualmode is not supported with this mode.
That’s correct ?

[DimitarParticipant]

Hi Tazi,

You can edit a grid with virtual mode enabled, but through the callback functions addrow, deleterow and updaterow, as shown in the tutorial Build CRUD Web App with jqxGrid using PHP and MySQL.

However, I still do not know why the issue you reported occurs. Are there any errors thrown in your browser’s console? If you can, please share a jsEditor/JSFiddle example we can test to reproduce the issue. Our recommendation is to implement server-side processing, though.

Best Regards,
Dimitar

jQWidgets team
http://www.jqwidgets.com/

[Author]

Posts