We're Moving to a New Support Platform – Starting June 1st!

We’re excited to let you know that starting June 1st, we’ll be transitioning to a new support system that will be available directly on our product websites – Amelia, wpDataTables, and Report Builder. In fact, the new support platform is already live for Amelia and wpDataTables, and we encourage you to reach out to us there.

You'll always be able to reach us through a widget in the bottom right corner of each website, where you can ask questions, report issues, or simply get assistance.

While we still do not offer live support, a new advanced, AI-powered assistant, trained on our documentation, use cases, and real conversations with our team, is there to help with basic to intermediate questions in no time.

We're doing our best to make this transition smooth and hassle-free. After June 1st, this current support website will redirect you to the new "Contact Us" pages on our product sites.

Thanks for your continued support and trust – we’re excited to bring you an even better support experience!

Okay
  Public Ticket #2558842
actual sql table creation
Closed

Comments

  • Dallasdawg started the conversation
    October 3, 2020 at 6:02pm

    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

  •  2,576
    Aleksandar replied
    October 5, 2020 at 12:32pm

    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