Advanced Filtering Not working. Setup MYSQL View of data. Can sort in MySQL Workbench just fine using view. Any text in sort field on WPDATATABLES produces zero results. MYSQL Version 5.5.62 and Wordpress Version 5.1.1. Query is MYSQL against simple view that pulls all records from single table.
Could you, please, show me what the query looks like? With this info, I can only tell you known issues with filtering and searching through SQL query based tables:
1. 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. If you use it, there's a possibility search and filters won't work.
2. The asterisk ( * ) can cause the table not to show if you have a certain security plugin installed. To get rid of the error, you need to move it to a new row, like this:
SELECT
* FROM mytable
3. Adding a semicolon at the end can cause issues with the query as well.
Advanced Filtering Not working. Setup MYSQL View of data. Can sort in MySQL Workbench just fine using view. Any text in sort field on WPDATATABLES produces zero results. MYSQL Version 5.5.62 and Wordpress Version 5.1.1. Query is MYSQL against simple view that pulls all records from single table.
Hello Bill.
Thank you for your purchase.
Could you, please, show me what the query looks like? With this info, I can only tell you known issues with filtering and searching through SQL query based tables:
1. 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. If you use it, there's a possibility search and filters won't work.
2. The asterisk ( * ) can cause the table not to show if you have a certain security plugin installed. To get rid of the error, you need to move it to a new row, like this:
3. Adding a semicolon at the end can cause issues with the query as well.
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