Okay
  Public Ticket #3730575
Hiding Rows
Closed

Comments

  • David Burley started the conversation

    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 ?

  •  1,846
    Miloš replied

    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 | InstagramFront-end and back-end demo | Docs

    Amelia: FAQ | Facebook | Twitter | InstagramAmelia 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