Hi, Franck 

Sorry for the delay

-

The charts are being created based on tables. 

If the table is server-side, then only the rows shown in the table will be loaded on the chart.

If the table is non-server-side, the chart will load all the rows, unless we enable "Follow table filtering" with the table on the same page.

-

Basically, if you have a Manual table;  they have automatically server-side enabled, we can't disable it.

So you would have to call an SQL Query to pull data out of the Manual Table;

then you have to disable server-side processing for it;

and disable "Follow table filtering"  - then the chart will load all rows.

-

Please let us know if anything is not clear, and if you have any questions.

Hi, Franck 

Firstly my sincere apologies for all the waiting time.

-

Sorry about that - you did mention that your tables are SQL , i shouldn't have mentioned the Manual tables.

For SQL Tables, if they are less than around 3000 rows - you will be able to disable server-side processing :

If you disable server-side processing, then your tables and charts will load all the rows.

-

Alternatively, you can set Default Rows Per page to load "All" -  but please be careful with that, if you have more than 3000 rows, the table might be extremely slow, or your page might even break.

But if you enable "Follow table filtering" with the table on the same page,then the chart will only present the rows that are in the table at the moment;   so if you do some filtering - it will only show filtered rows.

-

Let me know if that makes sense, and if you have any questions. Thank you

Hi, Franck

I can't see the image you sent :

But i believe i  can understand what you described - you goal would be to load all the rows for the chart;

but to have pagination ( for example 5 per page)...

-

I will double-check with our 2nd level Team, if we have any possibility or workaround to achieve that.

I honestly think that at this moment it's not possible, but  i will come back to confirm.

If that is the case, we can at least suggest it to our developers - and they will do their best to implement an option in the future.

We will come back to confirm that for you. Thank you

Hi, Franck

I got advised by our 2nd level Team.

- I am truly sorry to disappoint you, but at this time, this is not achievable with any of the functionalities in our plugin.

At this time, the chart logic is as we mentioned :

If the table is server-side, then only the rows shown in the table will be loaded on the chart.

If the table is non-server-side, the chart will load all the rows, unless we enable "Follow table filtering" with the table on the same page.

-

then you have to disable server-side processing for it;

and disable "Follow table filtering" - then the chart will load all rows.

-

But, we are unable to disable server-side for SQL tables that contain 3000 rows or more, at this time it's not possible.

If you suggest this to our developers, they will do their best to make a solution in the future.

Please feel free to search on our suggestions page, 

 to see if someone may be already suggested this feature. If you can't see it, feel free to add your suggestion there,  and as more people vote, the feature will move higher on the priority list.

You can certainly follow our changeLog page if you'd like ( it is also available in the plugin dashboard), where we state any changes/new features/bug fixes during updates;

and our newsletter, so you're informed about new features, bug fixes, freebies, etc.

-

At this time, the only workaround you could try is to export the table(s) from your database, as CSV format;

and then to link wpDataTable to CSV - then you will get the "non-server side" behaviour;

chart will load all rows;   but, when you got more than 3000 rows - the table will be extremely slow, and it can even break the page.

You can certainly try, if you wish. That is the only alternate solution i can think of at this time.