Not displaying information in database without deleting

Ask the community
, ,
1

I want to be able to keep information in my database without deleting it, but I also want to be able to pick and choose what shows up on my live website. Our association has members that sometimes take a year off from sponsorships, or miss the deadline for renewing membership. They are removed from the site until they pay their dues/rejoin. We have several that come in and out so I don’t want to delete their information all together. How can I “hide” some entries from showing on my live website but still have them available in my database for future use?

2

You can achieve it by filtering your database on excluding a specific data in specific field
Better with an example:
Let’s say that you took a year off from sponsorship :slight_smile:
and all the member names are stored on Database which you read with “dataset1” on your page…

import wixData from 'wix-data';    
$w.onReady(function () { 
    $w('#dataset1').setFilter( wixData.filter() //filtering dataset1 to show 
    .ne('member', 'Ali Alexander') ); //the items which is not equal to 
                                      //Ali Alexander on member field. 
});

Try to adapt this on your page and let me know if it works…
You can add a similar line when ever a member takes a break…