As previously announced via banners and our newsletters, support is no longer available through this platform.
For easier navigation, you can still click on "Submit a Ticket" here, choose the appropriate category, and you'll be redirected to the correct support channel for your plugin.
You can still access your previous tickets and browse public tickets, but please note that responding to tickets is no longer possible.
Paid customers: Please log in to your store account for support.
Pre-purchase questions: Use the support widget in the bottom-right corner of our websites:
https://wpamelia.com
https://wpdatatables.com
https://wpreportbuilder.com
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