I have noticed that although Server-side processing for MySQL-based tables is good for big tables, the chart that follows table filtering follows actually only those rows that are seen, not that are filtered. For example, "Showing 1 to 10 of 891 entries (filtered from 73,806 total entries)" chart would actually display 10 shown, not from 891. http://port-report.com/test3/
In the other example http://port-report.com/test2/, without server-side processing, with 2564 rows all works fine "Showing 1 to 10 of 891 entries (filtered from 2,564 total entries)" and chart actually draws from 891 entries as it should.
It is architectural decision that we make, because we can not guess number of the search results when using the server side. When using Server side and follow table filtering the chart will display only the current data that is shown in the table ( in your example 10).
The difference when Server side is not enabled is that the chart reads all of the data from the table and that is why it is working.
So unfortunately the chart can not display all of the data when Follow table filtering and Server side option is checked.
Hello.
I have noticed that although Server-side processing for MySQL-based tables is good for big tables, the chart that follows table filtering follows actually only those rows that are seen, not that are filtered. For example, "Showing 1 to 10 of 891 entries (filtered from 73,806 total entries)" chart would actually display 10 shown, not from 891. http://port-report.com/test3/
In the other example http://port-report.com/test2/, without server-side processing, with 2564 rows all works fine "Showing 1 to 10 of 891 entries (filtered from 2,564 total entries)" and chart actually draws from 891 entries as it should.
Is there a way to fix this?
Hi leolonya,
Thank you for your purchase.
It is architectural decision that we make, because we can not guess number of the search results when using the server side.
When using Server side and follow table filtering the chart will display only the current data that is shown in the table ( in your example 10).
The difference when Server side is not enabled is that the chart reads all of the data from the table and that is why it is working.
So unfortunately the chart can not display all of the data when Follow table filtering and Server side option is checked.
Best regards.
Kind Regards,
Miloš Jovanović
[email protected]
Rate my support
Try our FREE mapping plugin! MapSVG - easy Google maps, interactive SVG maps and floor plans, choropleth maps and much more - https://wordpress.org/plugins/mapsvg-lite-interactive-vector-maps/
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables