This workflow permanently deletes all entries from a table/tables which are matching the configured conditions.

The workflow is usually configured via a Workflow Scheduler which takes care of instantiating a workflow based on a schedule. Please see Configuring Workflow Scheduler for more information.

Workflow arguments

Name

Type

Description

ProtocolEnabled

System.Boolean

Write verbose messages to Logs. Default:True

TestOnly

System.Boolean

Simulates deletion. Default:True

TableIds

System.String

TableIds for which the workflow has been created.

IncludeProtected

System.Boolean

If True, allow to hard-delete entries that are marked delete protected.

Default: False

IncludeSoftDeletedOnly

System.Boolean

If False, allow to hard-delete entries that are not marked soft-deleted.

Default: True

EntryOlderThanDaysIfProtected

System.Int32

Hard-delete entries that are delete protected and older than the specified amount of days.

Disabled when set to -1.

Default: -1

EntryOlderThanDaysIfUnprotected

System.Int32

Hard-delete entries that are not delete protected and older than the specified amount of days.

Disabled when set to -1.

Default: -1

EntryUnchangedSinceDays

System.Int32

Hard-delete entries that are have not changed since the specified amount of days.

Disabled when set to -1.

Default: 30

EntryDeleteDateOlderThanDays

System.Int32

Hard-delete entries that have a delete date that lies in the past for more than the value specified

Disabled when set to -1.

Default: -1

Examples

  • Hard-delete entries that are soft-deleted and unchanged since 90 days

    IncludeSoftDeleteOnly = True
    IncludeProtected = True
    EntryUnchangedSinceDays = 90
    EntryOlderThanDaysIfProtected = -1
    EntryOlderThanDaysIfUnprotected = -1

  • Hard-delete entries that are soft-deleted and entry is older than 60 days

    IncludeSoftDeleteOnly = True
    IncludeProtected = True
    EntryUnchangedSinceDays = -1
    EntryOlderThanDaysIfProtected = 60
    EntryOlderThanDaysIfUnprotected = 60

  • Hard-delete entries that are delete protected and older than 30 days and entries that are not delete protected and older than 90 days, even when they are not soft-deleted

    IncludeSoftDeleteOnly = False
    IncludeProtected = True
    EntryUnchangedSinceDays = -1
    EntryOlderThanDaysIfProtected = 90
    EntryOlderThanDaysIfUnprotected = 30

  • Hard-delete everything in specified tables

    IncludeSoftDeleteOnly = False
    IncludeProtected = True
    EntryUnchangedSinceDays = -1
    EntryOlderThanDaysIfProtected = -1
    EntryOlderThanDaysIfUnprotected = -1


Use CaseIncludeSoftDeletedOnlyIncludeProtectedEntryOlderThanDays
IfUnprotected
EntryOlderThanDays
IfProtected
EntryUnchanged
SinceDays
EntryDeleteDate
OlderThanDays
DAVID defaultTrueFalse-1-130-1
SoftDeleted and entry unchanged since n daysTrueTrue-1-130-1
SoftDeleted and entry older than n daysTrueTrue9090-1-1
Older than n daysFalseTrue3060-1-1
Delete date reachedFalseTrue-1-1-10
EverythingFalseTrue-1-1-1-1

Logic: IncludeSoftDeleteOnly AND IncludeProtected AND EntryUnchangedSinceDays AND (EntryOlderThanDaysIfUnprotected OR EntryOlderThanDaysIfProtected OR EntryDeleteDateOlderThanDays)