PURGE

Purge records from table (data will be physically removed)

Example Usage

PURGE(Templates, Employees.TerminateDate, 30). // the date field can be in the target table, or in this case will be looked up

Overview

Function signature
PURGE(table, datefield, age)

Category
Database

Return data type
None

Arguments

Name	DataType	List Options	Description
table	lookup		The table from which data will be purged
datefield	string		The field in the target table to inspect for evaluating the condition
age	int		The elapsed days from the datefield through the current date after which to purge records