The plugin save the name table wrong when use `` in the name table and this affect the filter function.
When use
...FROM `table_name` with (``) the filter left to work because wpdatatables query add an additional `` to the query and the filter left to work... because
...FROM `table_name` WHERE ``table_name``.`field` ..... <-the plugin put double ```` in the table_name condition.
So the user must be use ...FROM table_name without `` to makes the filter works.
The plugin should be prevent in order to users could use both format with and without `` format.
I hope this help you to fix the problem in the future.
Only have to modify a couple of lines in your code
From version 2.3 we've implemented a feature that you can use multiple separate DB connections for MySQL, MSSQL and PostgreSQL. For MySQL engine we are dynamically adding the accent grave ( ` ), so there's no need to use it around the table name in the query.
The plugin save the name table wrong when use `` in the name table and this affect the filter function.
When use
...FROM `table_name` with (``) the filter left to work because wpdatatables query add an additional `` to the query and the filter left to work... because
...FROM `table_name` WHERE ``table_name``.`field` ..... <-the plugin put double ```` in the table_name condition.
So the user must be use ...FROM table_name without `` to makes the filter works.
The plugin should be prevent in order to users could use both format with and without `` format.
I hope this help you to fix the problem in the future.
Only have to modify a couple of lines in your code
Regards
Alejandro
Hello Alejandro
From version 2.3 we've implemented a feature that you can use multiple separate DB connections for MySQL, MSSQL and PostgreSQL. For MySQL engine we are dynamically adding the accent grave ( ` ), so there's no need to use it around the table name in the query.
Kind Regards,
Aleksandar Vuković
aleksandar.vukovic@tmsproducts.io
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