Purge a waitlist
An auto flush rule on the Reservation Waiting List (sn_wsd_rsv_waitlist) table purges expired waitlist records older than 30 days to maintain accurate waitlist management reporting.
Before you begin
Role required: sn_wsd_core.admin
About this task
Waitlist entries that are cancelled, expired, or fulfilled are purged automatically after 30 days (one month). The purge policy runs as a scheduled job. You can review the schedule and adjust settings to meet your organization's data retention requirements.
Procedure
Navigate to All and in the context filter menu, search for sys_auto_flush.LIST.
The Auto Flushes page opens.
In the Table name column, search for the waitlist.
Select the sn_wsd_rsv_waitlist table record.
Review the sn_wsd_rsv_waitlist record for purge configuration changes.
Note: A purge policy on the waitlist table purges records older than 30 days. It purges only records whose status is Confirmed, Failed, Expired, or Canceled.
Field Description Table name Reservation Waiting List [sn_wsd_rsv_waitlist] Match field Start Age in seconds 2,592,000 (equivalent to 30 days) Active True Conditions [status] [is] [confirmed] OR [status] [is] [failed] OR [status] [is] [expired] OR [status] [is] [cancelled] Adjust the retention period as needed for your organization's policy.
The Table Cleaner scheduled job runs periodically and reads the Auto Flush configuration for reservation waitlist table sn_wsd_rsv_waitlist table.
For each record in the sn_wsd_rsv_waitlist table, it verifies the following:
- Start time: Start time is 30 days or older from the current date.
- Status: Waitlist records with status Confirmed, Failed, Expired, or Canceled are purged from the system permanently.
- Select Update if you have made changes to this record.
By default, the job purges entries in Confirmed, Canceled, Expired, or Failed states that are older than 30 days.
Waitlist entries in terminal states older than the specified retention period are purged.
Parent Topic:Manage and configure reservation waitlist
Previous topic:Create a schedule job for waitlist
Next topic:Manage Workplace Reservations for Microsoft Outlook Add-in