User Tools

Site Tools


reference:spamrules_statement_dbdeletetime

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

reference:spamrules_statement_dbdeletetime [2018/11/14 10:45] (current)
Line 1: Line 1:
 +======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>​
 +
 +  * The comparator is < = > <= >= or <> (< is the most useful)
 +  * <​timevalue>​ is something like "5 seconds"​ or "10 minutes"​ or "3 weeks" (see PostgreSQL Interval Input - [[http://​www.postgresql.org/​docs/​9.1/​static/​datatype-datetime.html#​DATATYPE-INTERVAL-INPUT]]
 +
 +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)