I am unable to get search and filter to work properly. I followed your FAQ advice and created a SQL view (since I was using a JOIN in my first wpDatatables query) using an INNER JOIN. The revised wpDatatables query is configured to query the view and not use any JOIN statements.
I have confirmed that the view works as expected and the view is updatable since I am only updating one table.
I need to edit from the frontend, so disabling server-side processing is not an option.
What advice can you give me? I need searching and filtering to work while also allowing users to update in the frontend.
I got this figured out --- I was prepending the database name in my query. The interesting this is that wpDataTables was still able to properly access the target sql view and edit fields, but search and filtering for the table was broken. Simply removing the database name and instead leaving just the view name fixed the issue.
Thank you for letting us know the issue is resolved. Besides this, also make sure not to include accent graves ( ` ) around column names, and also don't use the semi-colon ( ; ) at the end of the query.
I am unable to get search and filter to work properly. I followed your FAQ advice and created a SQL view (since I was using a JOIN in my first wpDatatables query) using an INNER JOIN. The revised wpDatatables query is configured to query the view and not use any JOIN statements.
I have confirmed that the view works as expected and the view is updatable since I am only updating one table.
I need to edit from the frontend, so disabling server-side processing is not an option.
What advice can you give me? I need searching and filtering to work while also allowing users to update in the frontend.
I got this figured out --- I was prepending the database name in my query. The interesting this is that wpDataTables was still able to properly access the target sql view and edit fields, but search and filtering for the table was broken. Simply removing the database name and instead leaving just the view name fixed the issue.
Feel free to mark as closed.
Hello Mike
Thank you for letting us know the issue is resolved. Besides this, also make sure not to include accent graves ( ` ) around column names, and also don't use the semi-colon ( ; ) at the end of the query.
They can also cause similar behavior.
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