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%';]
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%';]
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?