Differences

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

--- reference:users_autoresponderconditions [2012/03/20 15:20] – created paul
+++ reference:users_autoresponderconditions [2012/03/20 15:23] – [Columns] paul
@@ Line 2: / Line 2: @@
 The [[db_Users|Users]].AutoresponderConditions table contains a record of all autoresponder trigger conditions created in VPOP3.
-These tell VPOP3 when a particular autoresponder should fire for a particular user. Each autoresponder can have zero or more conditions
+These tell VPOP3 when a particular autoresponder should fire for a particular user. Each autoresponder can have zero or more conditions. An autoresponder with zero conditions will never fire but can be reactivated later by adding a new condition.
 =====Columns=====
@@ Line 18: / Line 18: @@
   * datetimeto - the date & time this condition will act to (or NULL to be any date/time)
   * dow - text string indicating which days of the week this condition will act on (or NULL to be any day of week) - 0 is Saturday, 6 is Sunday (eg ''135'' means the condition will act on Monday, Wednesday and Friday)
-  * sender  - text string to match to the original message sender. If this begins with **/** then it is a [[http://www.postgresql.org/docs/9.1/static/functions-matching.html#FUNCTIONS-POSIX-REGEXP|regular expression match]] of the string surrounded by '/' characters, otherwise it is a [[http://www.postgresql.org/docs/9.1/static/functions-matching.html#FUNCTIONS-LIKE|case insensitive ILIKE match]]
+  * sender  - text string to match to the original message sender (or NULL to match any). If this begins with **/** then it is a [[http://www.postgresql.org/docs/9.1/static/functions-matching.html#FUNCTIONS-POSIX-REGEXP|regular expression match]] of the string surrounded by '/' characters, otherwise it is a [[http://www.postgresql.org/docs/9.1/static/functions-matching.html#FUNCTIONS-LIKE|case insensitive ILIKE match]]
-  * subject - text string to match to the original message subject. If this begins with **/** then it is a [[http://www.postgresql.org/docs/9.1/static/functions-matching.html#FUNCTIONS-POSIX-REGEXP|regular expression match]] of the string surrounded by '/' characters, otherwise it is a [[http://www.postgresql.org/docs/9.1/static/functions-matching.html#FUNCTIONS-LIKE|case insensitive ILIKE match]]
+  * subject - text string to match to the original message subject (or NULL to match any). If this begins with **/** then it is a [[http://www.postgresql.org/docs/9.1/static/functions-matching.html#FUNCTIONS-POSIX-REGEXP|regular expression match]] of the string surrounded by '/' characters, otherwise it is a [[http://www.postgresql.org/docs/9.1/static/functions-matching.html#FUNCTIONS-LIKE|case insensitive ILIKE match]]
   * locked - boolean. If this is set then the user cannot modify the conditions for this autoresponder (only an administrator can)
@@ Line 30: / Line 30: @@
 In any condition all the non-NULL conditions must match for the condition to match.
+A condition to match all the time would have the condid, autoresponderid, name, enabled, priority, usernumber and lock fields set, and the other fields set to NULL.

PSCS Wiki

User Tools

Site Tools

Differences

Page Tools