How to archive content without deleting in Content Manager

Ask the community
, , ,
1

Hi all! I have a database collection that contains data on upcoming events for my organization. I am currently using the sandbox to only show on the live site events that are upcoming (and removing events that have passed). This is a new database collection, so there’s not a ton of data in it yet. But I know there eventually will be. Is there a way to archive content from a database collection without permanently deleting it? I figure one way is to just create a separate database collection and store archived data there (using good old fashioned copy/paste). Thought I’d ask if there is an actual feature in Wix for archiving-but-not-deleting data in a database collection (to minimize how much I’m moving data around).

I’m also open to a coding solution to use on the dynamic page(s) itself that would filter out any events with past dates (the GUI filter in the Dataset Settings on the dynamic page only offers an “empty” vs “not empty” filter for the date/time field).

Thanks!!!

2

Can be done, but you will need some coding:

  1. setup a second collection (like “eventsOld”)
  2. run Job Scheduler every day/week, whatever you want, doing:
    3)select from original collection all rows you want gone
  3. bulk-insert them into the “eventOld” collection

If you don’t need this, but just prevent from showing old stuff, you can easily code this using Velo.

3

You can also enable the draft/published feature to control the visibility on the live site so no one else can access to draft content. No code is required. I don’t recommend filter on the dataset element because someone can still bypass the filter and see all data (similar to hack). if you need to go over the filter method, do it with the data.js (hook)