We are using HandsonTable pro version. We are currently facing an issue with the Filter plugin.
We are having the following concerns:
(1) The filter_by_value option is currently displaying only the items which are shown in the current page.We implemented custom pagination and we need to assign all the values in a particular column to the respective filter_by_value option in the filter plugin. Is there any way we can insert our data in a dataset which we can pass to the filter_by_value option in the filter plugin ?
(2) If the cell is a drop-down field the filter_by_option is displaying id instead of the text from the drop-down options. Is there a way we can display the text from drop down option?
Below is the screen cast for reference :
I have send the same information via email so please check it. I am pasting it as maybe users were asking the same question.
If you are using pagination sample from our tutorial at https://docs.handsontable.com/pro/1.11.0/demo-paginating.html you will always get only values from the selected page in the filter by value option. The reason lays in the logic of loading pages. As Handsontable doesn’t have tabs we created a fake paging via loading parts of data to the same instance.
With a current structure of Filters, which does not allow you to add an external source of data, I would recommend switching to hiddenRows which (for a user) acts the same as loading parts of data but allows to display all records from a table to the filter by value. We do not have a similar example online but I have managed to create a simple demo that shows how it works on a small dataset. Please take your time to test it: Handsontable example - JSFiddle - Code Playground I hope it will meet your project requirements.
When it comes to the second case I will check it and let you know.
We have very large amount of data.So dumping all the data at once to the page will affect the performance. So can u suggest other approach to handle bulk of data.
If you have a very large dataset I recommend handle filtering server-side. The following demo [quote=“aleksandra_budnik, post:2, topic:1148”] http://jsfiddle.net/handsoncode/g912eb3o/
[/quote]
works better for smaller sets as It calls updateSettings for a larger array of row indexes each time you click a new page.