User Tools

Site Tools


reference:spamrules_statement_dbqueryone

Differences

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

Link to this comparison view

Last revisionBoth sides next revision
reference:spamrules_statement_dbqueryone [2015/11/18 10:56] – created paulreference:spamrules_statement_dbqueryone [2015/11/18 11:08] paul
Line 22: Line 22:
     * last - returns the last matching record (by creation time)     * last - returns the last matching record (by creation time)
   * <comparator> can be [[spamrules_db_comparator|one of many values]]   * <comparator> can be [[spamrules_db_comparator|one of many values]]
 +  * If you set the variable ${_dbquerytime} to a PostgreSQL INTERVAL value (eg "5 minutes") then the query will only search for records which have been created/updated within that period - eg within the last 5 minutes.
  
 Example Example
reference/spamrules_statement_dbqueryone.txt · Last modified: 2018/11/14 10:45 by 127.0.0.1