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 #1639998
Is it possible to show specific rows?
Closed

Comments

  • Justin Hollender started the conversation
    July 12, 2018 at 5:00pm

    I'm looking for a way to display some pricing tables on my site. I want to create a master price table, and then on different pages of the site display specific rows of the table. For example:

    • Master price table contains
      • Home Model 1, Price 1, Price 2, Price 3
      • Home Model 2, Price 1, Price 2, Price 3
      • Home Model 3, Price 1, Price 2, Price 3
    • Home Model 1 page shows only the row related to prices for that model, and so on.

    Is this possible with wpDataTables?

  • [deleted] replied
    July 13, 2018 at 11:09am

    Hi Justin Hollender,
    Thank you for the inquiry.

    Something like that is possible if you create one Manual table where you will add all the data that you need, and in one column you add the ID's of the page (this column will not be visible on the front-end).

    Then you have to create the second table from MySQL query that will fetch the data from the first table and add condition to display just the data related to this page. e.g.

    SELECT * FROM wp_wpdatatable_1 WHERE id_column_name = %CURRENT_POST_ID%

    %CURRENT_POST_ID%  will be replaced with the ID of a currently active WordPress page or post. You can take a look at this feature at this page - Making dynamic SQL Queries with placeholders.

    You can try our sandbox site: Front-end & Back-end - you can find a fully functional version there to try out all plugin features.

  • Justin Hollender replied
    July 25, 2018 at 9:59pm

    Hey Milos,

    Thanks for the information. I'm trying to test this out in the sandbox admin area, but I can't figure out the second table setup. The first table is:

    ModelTacomaKingSalem
    Anna Belle110,000120,000125,000
    Sequoia310,900345,000320,900
    Ashton Park234,900250,900240,900

    Then I started setting up a page for the Anna Belle, which should only have the pricing from row 1 visible. Would I need to add another column to the table for the WordPress Post ID?

    Thanks,

    Justin

  • Justin Hollender replied
    July 25, 2018 at 10:30pm

    Milos,

    Actually, I figured it out. But the site refreshed and deleted my table from the sandbox while I was working on it.

  • [deleted] replied
    July 26, 2018 at 9:07am

    Hi Justin Hollender,

    Yes sandbox refreshes every 15th minute of every hour. If you have any more questions don't hesitate to ask.