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:

Amelia YouTube Channel

wpDataTables YouTube Channel

Thank you for your understanding, and we wish you a wonderful holiday weekend!

Okay
  Public Ticket #3767065
filtering table on wordpress post
Closed

Comments

  • Jonah started the conversation
    November 19, 2024 at 8:51pm

    I am confused as to how I would filter the output of the table.  I only want to display results on this post for where the Sector column contains "Electricity"

    I entered this is Placeholder variable 1
    SELECT * FROM my_table WHERE Sector LIKE '%Electricity%';

    Gutenberg embedded the following in my post.

    [wpdatatable id=23 table_view=regular var1=SELECT * FROM my_table WHERE Sector LIKE '%Electricity%';]

  •   Miloš replied privately
  • Jonah replied
    November 21, 2024 at 7:51pm

    I think I am explaining my problem poorly.  I have an Google Sheets based table which I imported.

    One of the columns in the sheet is "Sector".

    I have different posts on the site that need to display different sectors.

    How do I filter a single table to display a a different sector on each page in a site using Gutenberg?