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_

Field Name

Description

Version Added

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 "listmanager@". This attribute should work in conjunction with "Site" (below) to locate the phrase at the correct hierarchical level (varchar(60), NOT NULL)

 

DocID_

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

Changed column in 7.8.

Notify_

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

 

PgmAfter_

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

 

PgmBefore_

Program to execute before the action of a match 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)

 

Reject_

Whether to accept or reject the message in reponse to seeing this phrase. (bool, NOT NULL).

Added in 7.8.

Replace_

Replace the matched match 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(70), NOT NULL)