ms_filter Table (310)
•
Environment: onsite, online
Some tooltip text!
• 3 minutes to read
• 3 minutes to read
This table contains email filters. These are the filters allowing you to do advanced parsing of incomming emails.
Fields
| Name | Description | Type | Null |
|---|---|---|---|
| id | The primary key (auto-incremented) | PK | |
| priority | A number indicating the priority for this filter (0..10). | Int | |
| description | A description for this filter. | String(255) | ● |
| search_string | The string to search for. | String(255) | ● |
| search_string2 | A second string to search for. Only used if not empty. | String(255) | ● |
| search_location | Enum indicating where to search. | search_location | |
| action | A bitmask representing the actions that should be performed if this filter is executed. | Int | |
| action_when | Enum indicating what should trigger this filter. | action_when | |
| new_priority | The id of the priority to set for the ticket if specified by action. | FK ticket_priority | |
| new_category | The id of the category to set for the ticket if specified by action. | FK ej_category | |
| new_owner | The id of the owner to set for the ticket if specified by action. | FK ejuser | |
| new_slevel | The security level to set for the ticket if specified by action. | Int | |
| reply_template | The id of the template to use as the reply template if specified by action. | FK reply_template | |
| reply_to | The email address to reply to. | String(255) | ● |
| reply_to_sms | The SMS number to reply to. | String(255) | ● |
| body_template | The template to use for the body of the message. | FK reply_template | |
| forward_to | An email address to forward the ticket to. | String(255) | ● |
| autofaq_reply_category | The root folder for the auto faq search. | FK reply_template_folder | |
| flags | Flags | Int | ● |
| parse_mode | If automatic parsing this column indicate mode | Short | ● |
| ejscript | The reference to the ejscript to execute for this filter. | FK ejscript | ● |
| new_tags | The tags to set for tickets modified by this filter | FKArray | ● |
Indexes
| Fields | Types | Description |
|---|---|---|
| id | PK | Clustered, Unique |
| new_priority | FK | Index |
| new_category | FK | Index |
| new_owner | FK | Index |
| reply_template | FK | Index |
| body_template | FK | Index |
| autofaq_reply_category | FK | Index |
| ejscript | FK | Index |
| new_tags | FKArray | Full text |
Relationships
| Table | Description |
|---|---|
| ej_category | This table contains categories, in which tickets are categorized. The categories are organized in a hierarchial manner. |
| ejscript | ejscript |
| ejuser | This table contains entries for the users of the system. |
| ms_filter_mail | This table connects mail filters (ms_filter) to mailboxes (mail_in_filter). |
| ms_substitute | Regexp for extracting info from emails when they enter they system |
| ms_trashbin | This table contains entries for emails which have been trashed by a filter, waiting for confirmation of deletion or import. |
| reply_template | Templates for automatic and manual replies to emails/sms organized hierachically |
| reply_template_folder | This table contains entries for folders for reply templates. |
| Tags | MDO List of tags for Service entities |
| ticket_priority | This table contains the ticket priorities. |
Replication Flags
- None
Security Flags
- No access control via user's Role.