| 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 peripheral |
If selected, related records in these peripheral tables are also deleted:
- Attachment [sys_attachment] table
- Attachment Document [sys_attachment_doc] table
- Attachment Document V2 [sys_attachment_doc_v2] table
- Journal Entry [sys_journal_field] table
If cleared, the system deletes records from the target table, but not any related attachment or journal records in these tables. |
| 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. |
