Create a table cleanup rule in Core UI

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

Avant de commencer

Role required: admin

Procédure

1. Access the new Auto Flush form in one of the following ways.

   Option	Steps
   Using the Data Management Console	Navigate to All > System Data Management > Data Management Console > . On the Overview tab, select New cleanup rule.
   Using a data management policy	Navigate to All > System Data Management > Data Management Policies. Select the data management policy for the table with records that you want to delete. In the Table Cleanup Rules related list, select New.

2. On the form, fill in the fields.

   Tableau 1. Auto Flush form

   Field	Description`
   Tablename	The name of the target table.
   Matchfield	The 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 seconds	The amount of time the system waits before deleting records. When the Matchfield value becomes older than the Age in seconds, the record is deleted.
   Active	Option to activate or deactivate table cleaning for this table.
   Application	The application scope to which this table cleaner job applies.
   Clean journals	If 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 audit	If 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 delete	If 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.
   Conditions	Condition 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.

3. Select Submit.

Résultats

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