I would like to filter my clientinfo table by selecting a client from the choose client table. I have tried wpdatatables_filter_mysql_query &wpdatatables_before_get_table_metadata but no success.
Unfortunately this cannot be achieved using the plugin's builtin features. It is not yet possible to filter multiple tables with one filter.
I'll kindly ask you to add it as a feature suggestion on this page.
Features are pushed up on our "to-do" list when there are a lot of customers requesting those features, so having your vote as a customer can be beneficial to this feature being developed sooner.
It probably can be done with some custom work, but our developers are very busy at the moment, working on some priority tasks and fixing bugs and issues with our plugins, so they won't be having the time for custom work in near future.
But we can recommend these services for customization:
They do develop such solutions, so can you please send your inquiry to them?
You can add a filter through the shortcode if you assign one of our placeholders to column settings/filters/predefined filtering value.
If you add %VAR1% as a predefined filtering value to ColumnA, for example, it will load all the data (because the placeholder is not defined in the Placeholders tab above the table). Then, when you add the shortcode like:
[wpdatatable id=1 var1=150] it will filter the table per columnA with the value of "150".
I hope this helps, do let us know if you need any further assistance.
I would like to filter my clientinfo table by selecting a client from the choose client table. I have tried wpdatatables_filter_mysql_query &wpdatatables_before_get_table_metadata but no success.
Hi John
Thank you for reaching out to us.
Unfortunately this cannot be achieved using the plugin's builtin features. It is not yet possible to filter multiple tables with one filter.
I'll kindly ask you to add it as a feature suggestion on this page.
Features are pushed up on our "to-do" list when there are a lot of customers requesting those features, so having your vote as a customer can be beneficial to this feature being developed sooner.
It probably can be done with some custom work, but our developers are very busy at the moment, working on some priority tasks and fixing bugs and issues with our plugins, so they won't be having the time for custom work in near future.
But we can recommend these services for customization:
https://codeable.io/?ref=l1TW1
https://wpkraken.io/?tms-plugins
They do develop such solutions, so can you please send your inquiry to them?
You can add a filter through the shortcode if you assign one of our placeholders to column settings/filters/predefined filtering value.
If you add %VAR1% as a predefined filtering value to ColumnA, for example, it will load all the data (because the placeholder is not defined in the Placeholders tab above the table). Then, when you add the shortcode like:
[wpdatatable id=1 var1=150] it will filter the table per columnA with the value of "150".
I hope this helps, do let us know if you need any further assistance.