• Share
    • Twitter
    • LinkedIn
    • Facebook
    • Email
  • Feedback
  • Edit
Show / Hide Table of Contents

ms_filter Table (310)

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 ●

ms_filter table relationship diagram

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.
© SuperOffice. All rights reserved.
SuperOffice |  Community |  Release Notes |  Privacy |  Site feedback |  Search Docs |  About Docs |  Contribute |  Back to top