It seems that if I create a VIEW using 2 or more columns from CONCAT and then create a new wdDataTable as an SQL Query of that VIEW, the search function stops working. Using only one CONCAT column is fine however.
How big is the table? If it's not above 2.000 rows, I believe you could turn off server-side processing, and the search should work.
Usually issues like this are resolved creating views, but SQL is a complicated language, and integrating it with the plugin without any flaws is close to impossible. We're doing our best, though.
This is probably happening because wpDataTables server has problems parsing the query and building new queries dynamically.
If you can show me how you created the view, and how it looks, I can offer my thoughts, but can't promise anything.
I understand. I just thought you might like to know about the issue. I've been building everything with VIEWs and working around the problem. I should be good for now.
Thanks for letting us know about the issues you run into. We always appreciate these things being reported to us. It helps us develop the plugin better.
If you have any further questions or issues, please feel free to open a new ticket, and we'll gladly help.
It seems that if I create a VIEW using 2 or more columns from CONCAT and then create a new wdDataTable as an SQL Query of that VIEW, the search function stops working. Using only one CONCAT column is fine however.
Is this a bug or the nature of the plugin/MYSQL?
Hello withlovingarms.
How big is the table? If it's not above 2.000 rows, I believe you could turn off server-side processing, and the search should work.
Usually issues like this are resolved creating views, but SQL is a complicated language, and integrating it with the plugin without any flaws is close to impossible. We're doing our best, though.
This is probably happening because wpDataTables server has problems parsing the query and building new queries dynamically.
If you can show me how you created the view, and how it looks, I can offer my thoughts, but can't promise anything.
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
Thank for the reply.
I understand. I just thought you might like to know about the issue. I've been building everything with VIEWs and working around the problem.
I should be good for now.
Of course, withlovingarms.
Thanks for letting us know about the issues you run into. We always appreciate these things being reported to us. It helps us develop the plugin better.
If you have any further questions or issues, please feel free to open a new ticket, and we'll gladly help.
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