I was trying to think about how to only show an athletes most recent score in our leaderboard as unless things have changed you didn't have a means of hiding older duplicate entries ?
Is there any other way of instead just hiding individual rows, so the data is there still in the database but not shown on the front end. We could then hide all older entries ?
Sorry to disappoint you, but we don't have any built-in way to set up the table/column to only show one/most recent row and hide all other duplicate rows from it.
We do have the Conditional Formatting feature - but if you use that, it is going to hide all duplicates which match a certain condition.
You can make a development suggestion for the future.
to see if someone may be already suggested this feature. If you can't see it, feel free to add your suggestion there, and as more people vote, the feature will move higher on the priority list.
You can certainly follow our changeLog page if you'd like ( it is also available in the plugin dashboard), where we state any changes/new features/bug fixes during updates;
and our newsletter, so you're informed about new features, bug fixes, freebies, etc.
2. The only custom workaround idea I have it, to research online for examples of a Custom SQL Query which can call the data but limit it as you need from the database ( if this data is in our Manual table or Custom SQL Table);
I was trying to think about how to only show an athletes most recent score in our leaderboard as unless things have changed you didn't have a means of hiding older duplicate entries ?
Is there any other way of instead just hiding individual rows, so the data is there still in the database but not shown on the front end. We could then hide all older entries ?
Hi David,
Sorry to disappoint you, but we don't have any built-in way to set up the table/column to only show one/most recent row and hide all other duplicate rows from it.
We do have the Conditional Formatting feature - but if you use that, it is going to hide all duplicates which match a certain condition.
You can make a development suggestion for the future.
Please feel free to search on our suggestions page,
to see if someone may be already suggested this feature. If you can't see it, feel free to add your suggestion there, and as more people vote, the feature will move higher on the priority list.
You can certainly follow our changeLog page if you'd like ( it is also available in the plugin dashboard), where we state any changes/new features/bug fixes during updates;
and our newsletter, so you're informed about new features, bug fixes, freebies, etc.
2. The only custom workaround idea I have it, to research online for examples of a Custom SQL Query which can call the data but limit it as you need from the database ( if this data is in our Manual table or Custom SQL Table);
For example, this post from Stack overflow where a user wanted to "SQL query to select most recent of duplicates".
You can search for similar custom examples and try to modify it for your data, then call it via SQL Query based table.
Please note, custom Queries are not covered by our Support, but I hope this helps as a custom idea.
Kind Regards,
Miloš Jovanović
[email protected]
Rate my support
Try our FREE mapping plugin! MapSVG - easy Google maps, interactive SVG maps and floor plans, choropleth maps and much more - https://wordpress.org/plugins/mapsvg-lite-interactive-vector-maps/
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables