I can see the data, and it is an option in the multi-box select list in the header, as soon as i select it, it shows no data.
I can filter the primary table but not the connected tables.
Is there a way i can do this with the basic plugin?
I was looking at the Cascade Filters to WordPress tables with wpDataTables plugin, but in the example that I can see in the demo site it looks to me like it is simply querying one large data set, so is not necessarily going to help me. Could you advice?
Filtering, sorting, and search may not work properly if you include:
Accent graves ( ` ) around the table name
JOIN functions
UNION functions
CONCAT functions
sub-queries
You can try preparing a MySQL view (which will return the data that you need, call it e.g. “view1” and then build a wpDataTables based on a simple query like "SELECT * FROM view1″.
I am trying to filter my table.
It is an sql table with two left joins.
I can see the data, and it is an option in the multi-box select list in the header, as soon as i select it, it shows no data.
I can filter the primary table but not the connected tables.
Is there a way i can do this with the basic plugin?
I was looking at the Cascade Filters to WordPress tables with wpDataTables plugin, but in the example that I can see in the demo site it looks to me like it is simply querying one large data set, so is not necessarily going to help me. Could you advice?
Kind Regards
Hello Ana
Our logic is based on a PHP SQL parser which has full support for the SQL dialect for the following statement types
SELECT, INSERT, UPDATE, DELETE, REPLACE, RENAME, SHOW, SET, DROP, CREATE INDEX, CREATE TABLE, EXPLAIN and DESCRIBE.
Some of them are disabled for security reasons.
Filtering, sorting, and search may not work properly if you include:
You can try preparing a MySQL view (which will return the data that you need, call it e.g. “view1” and then build a wpDataTables based on a simple query like "SELECT * FROM view1″.
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
Try adding
SELECT * FROM (
`Your code here`
) tmp
Hi Daniel
Can you please explain a bit further what would you like us to do?
Were you able to create a view and pull the data to the table using SELECT * FROM view1 for example?
If you need more assistance in creating the view please have a look at this video