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
- Access the new Auto Flush form in one of the following ways.
| Option | Steps |
|---|---|
| Using the Data Management Console |
|
| Using a data management policy |
|
- On the form, fill in the fields.
| 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. |
- 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