When I filter a table which has a company name of test, and a filter value of "test", it shows "No matching records found" and the summary shows "Showing 1 to 0 of 11 entries (filtered from 112 total entries)." I get the same results no matter what column I filter by or for whatever value I enter!
Details:
View: "STANDARD"
DATA SOURCE: SQL query
Server-side processing: Enabled
Oh, I just discovered that if I DISABLE server-side processing, the filtering works!
Yes from version 2.3 we implement feature that you can use multiply separate db connections for (MySQL, MS SQL and PostgreSQL) and for MySQL engine we are dynamically adding accent grave (`). Please don't you accent grave or single quote on table names in query.
Advice for future please remove that accent grave (`) or single quote from query in query box and searching and filtering will work fine. Also avoid using semicolon in our query box on end of the query.
If you will use complicated quires and your MySQL-query based wpDataTable doesn’t work correctly with server-side processing, probably this is happening because wpDataTables server has problems with parsing of the query and building new queries dynamically (rarely happens, but does sometimes). To avoid this please prepare a MySQL view (a stored query), which will return the data that you need, call it e.g. “view1” and then build a wpDataTabled based on a simple query like “SELECT * FROM view1″.
When I filter a table which has a company name of test, and a filter value of "test", it shows "No matching records found" and the summary shows "Showing 1 to 0 of 11 entries (filtered from 112 total entries)." I get the same results no matter what column I filter by or for whatever value I enter!
Details:
View: "STANDARD"
DATA SOURCE: SQL query
Server-side processing: Enabled
Oh, I just discovered that if I DISABLE server-side processing, the filtering works!
I was able to get this working but simplifying the SQL from:
SELECT 'company'.'ID', 'company'.'name' FROM 'company';
to the following:
SELECT ID, name FROM company
Hi mgithens,
Thank you for your purchase.
Yes from version 2.3 we implement feature that you can use multiply separate db connections for (MySQL, MS SQL and PostgreSQL) and for MySQL engine we are dynamically adding accent grave (`). Please don't you accent grave or single quote on table names in query.
Advice for future please remove that accent grave (`) or single quote from query in query box and searching and filtering will work fine. Also avoid using semicolon in our query box on end of the query.
If you will use complicated quires and your MySQL-query based wpDataTable doesn’t work correctly with server-side processing, probably this is happening because wpDataTables server has problems with parsing of the query and building new queries dynamically (rarely happens, but does sometimes). To avoid this please prepare a MySQL view (a stored query), which will return the data that you need, call it e.g. “view1” and then build a wpDataTabled based on a simple query like “SELECT * FROM view1″.
Best regards.
Kind Regards,
Isidora Markovic
wpDataTables: FAQ | Facebook | Twitter | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Amelia demo sites | Docs
You can try our wpDataTables add-ons before purchase on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables