Holiday Notice – Support Unavailable on April 18 and April 21
We just wanted to let you know that our support team will be offline on Friday, April 18th (Good Friday) and Monday, April 21st (Easter Monday) due to the holidays.
We'll be back on Tuesday, ready to assist you!
In the meantime, if you need any help, feel free to:
-
Use the support widget in the bottom right corner on our websites (Amelia and wpDataTables) — our latest AI-powered assistant is there 24/7 to help with basic and intermediate questions,
-
Browse our detailed documentation (Amelia, wpDataTables)
-
Explore helpful articles,
-
Or check out our YouTube channels for video guides!
Amelia YouTube Channel
wpDataTables YouTube Channel
Thank you for your understanding, and we wish you a wonderful holiday weekend!
I have read as much as I can find in your docs but I don't see my specific use case. I need wpDataTables to create a sql table in my current wp database (wp_mydb) that is hosted on AWS Aurora. This is an example table schema.
CREATE TABLE `wp_XXXX_categories` (
`ID` bigint(11) NOT NULL AUTO_INCREMENT,
`category_text` varchar(125) COLLATE utf8mb4_unicode_520_ci NOT NULL,
`category_slug` varchar(125) COLLATE utf8mb4_unicode_520_ci NOT NULL,
`category` tinyint(1) NOT NULL,
`date_added` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (`ID`)
) ENGINE=InnoDB AUTO_INCREMENT=35 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
I then will populate the table through an aws lambda python based app.
Then I will need wpDataTables to enable me to generate reports and charts to display in Wordpress using the custom table above joined and filtered with other Wordpress data like user profile data, form data (formidiable), etc. Can this use case be executed with wpDataTables?
Thanks J
Hello Dallasdawg
Thank you for your interest in our plugin.
wpDataTables is not a database management tool, so it can't be used to create SQL tables. You can only use SELECT statement in our query box, and to create a table you would need to go through phpMyAdmin or some other database management tool.
Creating charts is possible with the data of an existing table, but generating reports can only be acheived with our paid add-on Report Builder.
What you're looking for to achieve doesn't seem possible with the plugin's built-in features, I'm afraid.
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