User Tools

Site Tools


reference:spamrules_statement_dbdeletetime

Spam Filter Rules: DBDeleteTime

Statement DBDeleteTime
Version 6.16+
Purpose Deletes records from the spam filter database based on their last update time

The DBDeleteTime statement requires a component name, comparator and time value, in the format

DBDeleteTime <component name> <comparator> <timevalue>

Example

DBDeleteTime subject < "3 months"

This will delete all records for the 'subject' component which were last updated earlier than 3 months ago.

The SQL expression is created as 'updatetime <comparator> now() - <timevalue>', so the above statement's query string becomes where updatetime < now() - '3 months'

reference/spamrules_statement_dbdeletetime.txt · Last modified: 2018/11/14 10:45 (external edit)