I run a couple of Dynamic Pivot Table Procedure on my DB. These procedures creates extra columns (intentionally) In some case I don't need some of the columns (as they are zero). With the parameters I could create individual table and delete them afterwards. But I can't use Call "procedure" in the qry window op wpdatatables.
Is there an other way to achieve this? In other word is Select the only statement we can use in the Qry window?
With stored procedure it could possible be a problem because we are using php parser to manipulate a query and it doesn't support CALL. If you can return results with statement types that mentioned parser supported it will most probably work in the plugin. Full support for the MySQL dialect for the following statement types
SELECT INSERT UPDATE DELETE REPLACE RENAME SHOW SET DROP CREATE INDEX CREATE TABLE EXPLAIN DESCRIBE
Please not that DELETE and DROP are sanitized because of security reasons.
Hi Team,
I run a couple of Dynamic Pivot Table Procedure on my DB.
These procedures creates extra columns (intentionally) In some case I don't need some of the columns (as they are zero).
With the parameters I could create individual table and delete them afterwards.
But I can't use Call "procedure" in the qry window op wpdatatables.
Is there an other way to achieve this?
In other word is Select the only statement we can use in the Qry window?
Hi Marc,
Thank you for your purchase.
With stored procedure it could possible be a problem because we are using php parser to manipulate a query and it doesn't support CALL. If you can return results with statement types that mentioned parser supported it will most probably work in the plugin. Full support for the MySQL dialect for the following statement types
SELECT
INSERT
UPDATE
DELETE
REPLACE
RENAME
SHOW
SET
DROP
CREATE INDEX
CREATE TABLE
EXPLAIN
DESCRIBE
Please not that DELETE and DROP are sanitized because of security reasons.
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