Trying to get an understanding of what MySQL commands are supported. If the query itself 100% functional, for example we have a local MySQL DB with the following query:
SELECT *, INET_ATON(IP) AS IP_sort, INET_ATON(privateip) AS privateip_sort, REPLACE(LEFT(name,5),'-','')AS blade, REPLACE(RIGHT(name,2),'-','')+0 AS sort
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″.
Trying to get an understanding of what MySQL commands are supported. If the query itself 100% functional, for example we have a local MySQL DB with the following query:
SELECT *, INET_ATON(IP) AS IP_sort, INET_ATON(privateip) AS privateip_sort, REPLACE(LEFT(name,5),'-','')AS blade, REPLACE(RIGHT(name,2),'-','')+0 AS sort
Will you support this?
Hello Frank
Thank you for your interest in our plugin.
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.
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