jadly

How can you get the total of records to be displayed using “where” ?

Yes the total available rows from the source.

How about totals of each subset of the table based on filters? I have a column in my tables indicating whether the row should be published. Rather than creating another subset table of just the published data, it would be good to upload the entire table, and let mpg sort it out. I also have other pages that show subsets of table data, and it would be good to show a total count of the data to be displayed.

Hi. I provided the shortcode after the request, and then a row after the request, and unfortunately the shortcode didn’t relate to the row I provided. My apologies.

I had an issue with 4.0.0. (as per the screen shots), but now I’ve updated to the latest version 4.0.1.

The site is working well.

yes that would be handy ??

I’ve added them

https://docs.google.com/spreadsheets/d/12jibQPd24rZio8gAwun6lO-qAAb8B4gmZ9ipnKNbICA/edit?usp=sharing

https://docs.google.com/spreadsheets/d/12jibQPd24rZio8gAwun6lO-qAAb8B4gmZ9ipnKNbICA/edit

please let me know if you can’t view it. It is 1 row

Yes that is correct.

sure

[mpg project-id=”7″ operator=”and” where=”mpg_status=Published;mpg_target=children;mpg_difficulty=an easy;”]{{mpg_title}}
{{mpg_short_desciption}}[/mpg]

I’m trying again….. hope to get better results. Will let you know

thank you for a quick reply. However after inserting the short codes, the info from the table is not appearing in the source of the page

This is my Yoast SEO config

This is the HTML generated, it contains mpg_title instead of the table value of “Giraffe Gentle Giants”

The page content is showing ok. Its just not populating the yoast SEO correctly. Part of the page displayed is below. The bold items and image are generated from the table ok.

I’ve now loaded the latest version of your plugin, and all ok. It was the old PHP version. I apologise for not keeping PHP up to date.

I apologise for not sharing before… since the abend I updated PHP.

It is now 7.4.10… before it was below 7.

I’ve turned off the auto updating of tables, but I may try updating the plugin and see what happens now…. and its all OK.

I’ve turned on the auto update of plugins.

And learnt a lesson about keeping PHP updated.

– Plugin version 1.2.9
– WordPress version 5.5.1
– Browser type Chrome 84.0.4147.125 (Official Build) (64-bit)
– Operating system MacOS Catalina 10.16.6
– Live url https://eighteenpointfive.com.au/team/ (the latest update seems to have caused the fatal error, and I cannot display tables)