Hi, I have purchased and installed your plugin and filters add-on. Everything is great, but I cannot search for partial phrases in my SQL queried table. As you can see on my screenshots for the specific name, if I search for a part of it, it shows no results. Is that not possible in this case, or do I miss any settings? Thanks, Andy
Filtering, sorting, and search may not work properly if you include:
Accent graves ( ` ) around the table name
JOIN functions
UNION functions
CONCAT functions
sub-queries
You can try preparing a MySQL view (which will return the data that you need, call it e.g. “view1” and then build a wpDataTables based on a simple query like "SELECT * FROM view1″.
Hi, Aleksandar! Thank you for getting back. Actually, it is a simple query [SELECT * FROM `wp_xxxx`] which works fine. It shows the results correctly in the wpDataTables. But I can't filter the results in this table. If I put in a string into the search field, it shows no results. Regards, Andy
Hi, Aleksandar! That did the trick, thanks for helping! Great! I love your plugin btw. you guys did a fantastic job, :) Will give you a 5-star review. Regards, Andy
Hi, I have purchased and installed your plugin and filters add-on. Everything is great, but I cannot search for partial phrases in my SQL queried table. As you can see on my screenshots for the specific name, if I search for a part of it, it shows no results. Is that not possible in this case, or do I miss any settings? Thanks, Andy
Hello Andreas
Thank you for your purchase.
Our logic is based on a PHP SQL parser which has full support for the SQL dialect for the following statement types
SELECT, INSERT, UPDATE, DELETE, REPLACE, RENAME, SHOW, SET, DROP, CREATE INDEX, CREATE TABLE, EXPLAIN and DESCRIBE.
Some of them are disabled for security reasons.
Filtering, sorting, and search may not work properly if you include:
You can try preparing a MySQL view (which will return the data that you need, call it e.g. “view1” and then build a wpDataTables based on a simple query like "SELECT * FROM view1″.
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! Thank you for getting back. Actually, it is a simple query [SELECT * FROM `wp_xxxx`] which works fine. It shows the results correctly in the wpDataTables. But I can't filter the results in this table. If I put in a string into the search field, it shows no results. Regards, Andy
Hi again Andy
Please try removing the accent graves ( ` ) from around the table name.
Let me know if that helped.
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! That did the trick, thanks for helping! Great! I love your plugin btw. you guys did a fantastic job, :) Will give you a 5-star review. Regards, Andy
Awesome, Andy, thank you very much!
I'm glad that a simple solution resolved the issue.
If you have any further questions or issues, please feel free to open a new ticket, and we'll gladly help.
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