User Tools

Site Tools



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

Link to this comparison view

Next revision
Previous revision
reference:spamrules_statement_dbqueryone [2015/11/18 10:56]
paul created
reference:spamrules_statement_dbqueryone [2018/11/14 10:45] (current)
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 (external edit)