Skip to content
Release: Australia · Updated: 2026-03-12 · Official documentation · View source

Create a table cleanup rule in Core UI

Define the criteria for deleting unwanted records in a table cleanup rule.

Before you begin

Role required: admin

Procedure

  1. Access the new Auto Flush form in one of the following ways.
OptionSteps
Using the Data Management Console
  1. Navigate to All > System Data Management > Data Management Console > ****.
  2. On the Overview tab, select New cleanup rule.
Using a data management policy
  1. Navigate to All > System Data Management > Data Management Policies.
  2. Select the data management policy for the table with records that you want to delete.
  3. In the Table Cleanup Rules related list, select New.
  1. On the form, fill in the fields.
FieldDescription\`
TablenameThe name of the target table.
MatchfieldThe Date/Time field in the target table that is used to monitor duration. Defaults to sys\_created\_on, which deletes records based on the amount of time since their creation date.
Age in secondsThe amount of time the system waits before deleting records. When the Matchfield value becomes older than the Age in seconds, the record is deleted.
ActiveOption to activate or deactivate table cleaning for this table.
ApplicationThe application scope to which this table cleaner job applies.
Clean journalsIf selected, related records in the Journal Entry \[sys\_journal\_field\] table are also deleted.If cleared, the system deletes records from the target table, but not any related journal records in this table.
Clean auditIf selected, related records in these audit tables are also deleted:- Sys Audit \[sys\_audit\] table - Audit Relationship Change \[sys\_audit\_relation\] table Note that the audit records that are created by table cleaner in the Audit Deleted Record \[sys\_audit\_delete\] table are preserved. If cleared, the system deletes records from the target table, but not any related audit records in these tables.
Cascade deleteIf selected, this option deletes all matching records plus any records referring to them. If cleared, the system deletes matching records, but not records referring to them.
ConditionsCondition builder for specifying filter conditions that define the records to be removed. For example, you might specify that only records where 'active = false AND state =closed' are deleted.
  1. Select Submit.

Result

The table cleanup rule runs automatically and deletes records when they meet the specified record age and any conditions that you set for them.

Parent Topic:Deleting older or unwanted records in Core UI