Summary of the "phrases_" fields in ListManager

The phrases_ table holds "phrases" words that should trigger a specific action. You define the phrase, where in the message to search, and what to do when the phrase is found.

 

 

Primary key: PhraseID_

 

 

AppliesTo_

What fields does this apply to: all, body, subject, from, header, subject-body, etc. (varchar(30), NOT NULL)

Context_

In what context does this apply: $listname, "all lists", "all sites", or "lyris@". This attribute should work in conjunction with "Site" (below) to locate the phrase at the correct hierarchical level (varchar(20), NOT NULL)

DocTitle_

What document should be mailed/displayed in response to seeing this phrase (varchar(200), NOT NULL)

Notify_

Email addresses to notify when this responder is requested (text, NULL)

PgmAfter_

Program to execute after the action of an action phrase (text, NULL)

PgmBefore_

Program to execute before the action of an action phrase (text, NULL)

Phrase_

The phrase words to search for. If more than one, separated by a carriage return (text, NULL)

PhraseID_

Unique ID for this phrase (int, Identity, NOT NULL)

Replace_

Replace the matched action phrase text with this text (text, NULL)

Site_

Name of site this applies to. This field can be a sitename, a listname (in the form of "list $listname"), or "all" to designate a server-level phrase (varchar(50), NOT NULL)

 



respond_ log_