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
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