Purge a waitlist

  • Release version: Yokohama
  • Updated May 22, 2026
  • 1 minute to read

    • 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

    1. Navigate to All and in the context filter menu, search for sys_auto_flush.LIST.

      The Auto Flushes page opens.

    2. In the Table name column, search for the waitlist.
    3. Select the sn_wsd_rsv_waitlist table record.
    4. 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.
      Table 1. Purge record form
      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]
    5. Optional: Adjust the retention period as needed for your organization's policy.
    6. 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.
    7. Optional: 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.