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 #2927271
Dynamic Page Template
Closed

Comments

  • Adam started the conversation

    Is it possible to create a custom WordPress page template that would query a wpDataTable based on query string?

    For example,

    /folder/page/?id=17

     - Would load a page tied to custom template (page-whatever.php)

    Inside page-whatever.php I would need to:

    1) query wpDataTables table like so: select field_1, field_2 from tblwhatever where id = $id   (17 would be passed in from the querystring)

    2) return single record where I can display page as I would like with defined format.

    As example

    <h1>$field_1</h1>

    <p>Name: $field_2</p>


  •  472
    Isidora replied

    Hi Adam,

    Thank you for your purchase.

    Sorry for the late response, we have some agents that have contracted Covid-19, so our team is cut in half.

    If I understand you right that would be maybe possible but only with manual tables(when you create it it will be created table in database), for SQL you already have that tables in database that you can use in your template and all other are not related with saving data in database(Excel,CSV,Google sheet...) 

    In our database you have wpdatatables table where are saved table settings(without data from source-only content to the source), wpdatatables_columns where is saved columns settings.

    So select field_1, field_2 from tblwhatever where id = $id will not work as you expected.

    At the moment we do not option for single sell shortcode but it will be available in near future.

    Best regards.

    Kind Regards, 

    Isidora Markovic

    wpDataTables: FAQFacebookTwitterFront-end and back-end demoDocs

    Amelia: FAQFacebookTwitter |  Amelia demo sites | Docs

    You can try our wpDataTables add-ons before purchase on these sandbox sites:

    Powerful FiltersGravity Forms Integration for wpDataTablesFormidable Forms Integration for wpDataTables