I defined a wpdatatable via an sql query and it works and looks great. Unfortunatly searching within the table does not work. If I type something in the search field, there are bo results. I red that sometimes there a problems with queries and one should use an sql view instead. Within my query I use some placeholders such as actual user id, so my question: I dont see a solution with sql view because of the placeholders, how can I reach a working table with search function?
Sorry to disappoint You, but this cannot be done with the plugin's built-in features.
You can remove our placeholders and the conditions You used for the placeholders; create a view, and then find a way to use those conditions in the new query.
You can always provide us with a temporary WP-admin login for your site where this happens, so we could log in and take a look ‘from the inside’ as that’s the most efficient way to see and resolve the issue. We do not interfere with any data or anything else except for the plugin (in case that’s a production version of the site), and of course we do not provide login data to third party. You can write credentials here just check Private Reply so nobody can see them except us.
Hello,
I defined a wpdatatable via an sql query and it works and looks great. Unfortunatly searching within the table does not work. If I type something in the search field, there are bo results. I red that sometimes there a problems with queries and one should use an sql view instead. Within my query I use some placeholders such as actual user id, so my question: I dont see a solution with sql view because of the placeholders, how can I reach a working table with search function?
Thanks and Best
Mitja
Hello Mitja.
Thank You for Your purchase.
Sorry to disappoint You, but this cannot be done with the plugin's built-in features.
You can remove our placeholders and the conditions You used for the placeholders; create a view, and then find a way to use those conditions in the new query.
You can always provide us with a temporary WP-admin login for your site where this happens, so we could log in and take a look ‘from the inside’ as that’s the most efficient way to see and resolve the issue. We do not interfere with any data or anything else except for the plugin (in case that’s a production version of the site), and of course we do not provide login data to third party. You can write credentials here just check Private Reply so nobody can see them except us.
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