If you're creating a table using SQL queries, the table will change depending on the query entered in the back-end. So if you have the same table on different sources, with different data, you can simply change the query and it will display a different table. Please note, though, that both sources must be in the same database. Once you choose the database from which the table will be created, you can no longer change that.
If you meant to ask something else, please explain in a bit more detail.
I need to make a comparison table for home loans. The filter form has some advanced logic and the elements which are not available in wpdatatables, please find a screenshot attached. I was thinking if it's possible to develop our own filter form and update wpdatatable on the client. Do you think we can use wpdatatables for that?
The check-box filter is available with our plugin:
I also see number range sliders, which are available for integer and float columns.
Also, you can add conditional formatting to apply rules where value > 95% is red, 90% < 95% is orange, and so on.
You would just need to configure the filters. Also, more options like "Cascade filtering" and "Hiding the table before filters are applied" can be achieved with our Powerful Filters paid add-on.
You should be able to create custom filtering form using filters and hooks, but as that is considered a custom solution, it is not included in the support of the plugin.
Hi,
Is it possible to update the datasource and redraw a table from the client side?
E.g. we have our own filter form which will update a server-side datasource by changing some parameters and update WPDataTables?
Hello Igor.
Thank you for your interest in our plugin.
If you're creating a table using SQL queries, the table will change depending on the query entered in the back-end. So if you have the same table on different sources, with different data, you can simply change the query and it will display a different table. Please note, though, that both sources must be in the same database. Once you choose the database from which the table will be created, you can no longer change that.
If you meant to ask something else, please explain in a bit more detail.
Best regards.
Kind Regards,
Aleksandar Vuković
[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 Aleksandar,
I need to make a comparison table for home loans. The filter form has some advanced logic and the elements which are not available in wpdatatables, please find a screenshot attached. I was thinking if it's possible to develop our own filter form and update wpdatatable on the client. Do you think we can use wpdatatables for that?
Best regards, Igor
Hello again Igor.
The check-box filter is available with our plugin:
I also see number range sliders, which are available for integer and float columns.
Also, you can add conditional formatting to apply rules where value > 95% is red, 90% < 95% is orange, and so on.
You would just need to configure the filters. Also, more options like "Cascade filtering" and "Hiding the table before filters are applied" can be achieved with our Powerful Filters paid add-on.
You should be able to create custom filtering form using filters and hooks, but as that is considered a custom solution, it is not included in the support of the plugin.
Best regards.
Kind Regards,
Aleksandar Vuković
[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