I've set up a table and created a chart from it. In visualization settings I configured 50 records per page. If I show the chart without table in page chart only returns first 10. I tryed setting limit in sql to 50 with no success. How can I show all records instead just first 10?
That is why I asked you if the Follow table filtering is checked. When that option is checked the chart will display the same number of results as the results that are shown in the table. My suggestion is to put the chart and the table on the same page. Define how many entries would you like to show in the table and then hide that table with CSS.
The "issue" is that the table must be server side in order for follow table filtering option to work.
When the Follow table filtering option is checked the chart will always display the data that is currently displayed in the table and that table must be in the same page as chart or the chart will only display the first 10 values.
So that is why i suggested you to use this workaround and unfortunately this is how it works for now.
Hi
I've set up a table and created a chart from it. In visualization settings I configured 50 records per page. If I show the chart without table in page chart only returns first 10. I tryed setting limit in sql to 50 with no success. How can I show all records instead just first 10?
Thanks
Best regards
Hi Raul,
Thank you for your purchase.
Can you please tell me is follow table filtering option checked for that chart in chart wizard. ( attachment)
Best regards.
Kind Regards,
Miloš Jovanović
[email protected]
Rate my support
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
HI Raul,
That is why I asked you if the Follow table filtering is checked.
When that option is checked the chart will display the same number of results as the results that are shown in the table.
My suggestion is to put the chart and the table on the same page. Define how many entries would you like to show in the table and then hide that table with CSS.
Best regards.
Kind Regards,
Miloš Jovanović
[email protected]
Rate my support
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
Hi Bogdan
I understand but I set the table to show All records. I even tried with 25, 50 and 100. But it always shows 10 unless table is rendered in the page.
Of course, your suggestion to render the related table into the page and hide it with css works, but it's not the desired way is it?
Thanks
Hi Raul,
The "issue" is that the table must be server side in order for follow table filtering option to work.
When the Follow table filtering option is checked the chart will always display the data that is currently displayed in the table and that table must be in the same page as chart or the chart will only display the first 10 values.
So that is why i suggested you to use this workaround and unfortunately this is how it works for now.
Best regards.
Kind Regards,
Miloš Jovanović
[email protected]
Rate my support
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