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