|
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.
|