Class MailInFilterTableInfo

Table 'mail_in_filter': This table contains entries for the mailboxes the eJournal system is fetching mail from (POP3 or IMAP).

Inheritance
System.Object
TableInfo
MailInFilterTableInfo
Implements
System.ICloneable
Inherited Members
Namespace: SuperOffice.CRM.Data
Assembly: SoDataBase.dll
Syntax
[DatabaseTable("mail_in_filter")]
public class MailInFilterTableInfo : TableInfo, ICloneable
Remarks

An instance of this class represents one instance of this table in an SQL statement. In most cases each table appears only once in a SELECT, but in cases where you need to self-join, or there are multiple occurrences for other reasons (typically additional restrictions in the joins), then you will need multiple instances.
Instances of this class are created by calling .

Fields

DictionaryTableName

Conceptual name of table MailInFilter in the database dictionary: mail_in_filter

Declaration
public const string DictionaryTableName = "mail_in_filter"
Field Value
Type Description
System.String

Properties

Address

Field 'address' in table 'mail_in_filter': Dictionary type String[256], .NET type: System.String

The address associated with this mailbox (used as FROM: address when sending emails).

Declaration
public StringFieldInfo Address { get; }
Property Value
Type Description
StringFieldInfo

AiSuggestCategory

Field 'ai_suggest_category' in table 'mail_in_filter': Dictionary type Bool, .NET type: System.Int16

If this is set to 0 (false), then there will be no AI for suggesting categories on incoming emails

Declaration
public UInt16FieldInfo AiSuggestCategory { get; }
Property Value
Type Description
UInt16FieldInfo

AiTextAnalysis

Field 'ai_text_analysis' in table 'mail_in_filter': Dictionary type Bool, .NET type: System.Int16

If this is set to 0 (false), then there will be no AI text analysis on incoming emails

Declaration
public UInt16FieldInfo AiTextAnalysis { get; }
Property Value
Type Description
UInt16FieldInfo

Autofaq

Field 'autofaq' in table 'mail_in_filter': Dictionary type Bool, .NET type: System.Int16

Whether to suggest FAQ entries for this email account or not

Declaration
public UInt16FieldInfo Autofaq { get; }
Property Value
Type Description
UInt16FieldInfo

AutofaqKbCategory

Field 'autofaq_kb_category' in table 'mail_in_filter': Dictionary type FK, target: KbCategory, .NET type: System.Int32

The root folder for the auto faq search.

Declaration
public Int32FieldInfo AutofaqKbCategory { get; }
Property Value
Type Description
Int32FieldInfo

AutofaqKbCategory_InnerJoin_KbCategory

Generated join from the foreign key AutofaqKbCategory in this table, to its target table KbCategoryTableInfo.

Declaration
public TargetedInnerJoin<KbCategoryTableInfo> AutofaqKbCategory_InnerJoin_KbCategory { get; }
Property Value
Type Description
TargetedInnerJoin<KbCategoryTableInfo>

CategoryId

Field 'category_id' in table 'mail_in_filter': Dictionary type FK, target: EjCategory, .NET type: System.Int32

The id of the category this mailbox assigns tickets to (unless overridden by a sortfilter).

Declaration
public Int32FieldInfo CategoryId { get; }
Property Value
Type Description
Int32FieldInfo

CategoryId_InnerJoin_EjCategory

Generated join from the foreign key CategoryId in this table, to its target table EjCategoryTableInfo.

Declaration
public TargetedInnerJoin<EjCategoryTableInfo> CategoryId_InnerJoin_EjCategory { get; }
Property Value
Type Description
TargetedInnerJoin<EjCategoryTableInfo>

Checkwait

Field 'checkwait' in table 'mail_in_filter': Dictionary type Int, .NET type: System.Int32

How often (in minutes) to check this mailbox.

Declaration
public Int32FieldInfo Checkwait { get; }
Property Value
Type Description
Int32FieldInfo

Definition

Definition of the table as described in the deployed runtime dictionary

Declaration
public override SoTable Definition { get; }
Property Value
Type Description
SoTable
Overrides

DictionaryTableNumber

Table number for table MailInFilter in the database dictionary; potentially changes between databases, but always the same over the lifetime of any single database

Declaration
public int DictionaryTableNumber { get; }
Property Value
Type Description
System.Int32

Domain

Field 'domain' in table 'mail_in_filter': Dictionary type String[256], .NET type: System.String

The domain used to login.

Declaration
public StringFieldInfo Domain { get; }
Property Value
Type Description
StringFieldInfo

ImportmailPid

Field 'importmail_pid' in table 'mail_in_filter': Dictionary type Int, .NET type: System.Int32

The process id of the importMail instance processing this mailbox

Declaration
public Int32FieldInfo ImportmailPid { get; }
Property Value
Type Description
Int32FieldInfo

KeepHeaders

Field 'keep_headers' in table 'mail_in_filter': Dictionary type String[256], .NET type: System.String

A commaseparated list of headers to store for emails imported. E.g. 'to,from,recieved-by,subject'.

Declaration
public StringFieldInfo KeepHeaders { get; }
Property Value
Type Description
StringFieldInfo

LanguageId

Field 'language_id' in table 'mail_in_filter': Dictionary type FK, target: CustLang, .NET type: System.Int32

The id of the customer language entry this entry is connected to.

Declaration
public Int32FieldInfo LanguageId { get; }
Property Value
Type Description
Int32FieldInfo

LanguageId_InnerJoin_CustLang

Generated join from the foreign key LanguageId in this table, to its target table CustLangTableInfo.

Declaration
public TargetedInnerJoin<CustLangTableInfo> LanguageId_InnerJoin_CustLang { get; }
Property Value
Type Description
TargetedInnerJoin<CustLangTableInfo>

LastError

Field 'last_error' in table 'mail_in_filter': Dictionary type Clob, .NET type: System.String

The last error message recieved from the underlying email system (such as POP3 protocol errors, etc).

Declaration
public StringFieldInfo LastError { get; }
Property Value
Type Description
StringFieldInfo

LastSuccess

Field 'last_success' in table 'mail_in_filter': Dictionary type DateTime, .NET type: System.DateTime

Datetime indicating the last time email was sucessfully imported from this mailbox. Used to display warnings when this value is getting too old.

Declaration
public DateTimeFieldInfo LastSuccess { get; }
Property Value
Type Description
DateTimeFieldInfo

LastTry

Field 'last_try' in table 'mail_in_filter': Dictionary type DateTime, .NET type: System.DateTime

Datetime indicating the last time this mailbox tried (but possibly failed) to fetch email.

Declaration
public DateTimeFieldInfo LastTry { get; }
Property Value
Type Description
DateTimeFieldInfo

LeftOuterJoin_Inbox_MailInFilter

Generated left outer join from the primary key MailInFilterId on this table, to Inbox.MailInFilter.

Declaration
public TargetedLeftOuterJoin<InboxTableInfo> LeftOuterJoin_Inbox_MailInFilter { get; }
Property Value
Type Description
TargetedLeftOuterJoin<InboxTableInfo>

LeftOuterJoin_MailAlias_FilterId

Generated left outer join from the primary key MailInFilterId on this table, to MailAlias.FilterId.

Declaration
public TargetedLeftOuterJoin<MailAliasTableInfo> LeftOuterJoin_MailAlias_FilterId { get; }
Property Value
Type Description
TargetedLeftOuterJoin<MailAliasTableInfo>

LeftOuterJoin_MailInUidl_FilterId

Generated left outer join from the primary key MailInFilterId on this table, to MailInUidl.FilterId.

Declaration
public TargetedLeftOuterJoin<MailInUidlTableInfo> LeftOuterJoin_MailInUidl_FilterId { get; }
Property Value
Type Description
TargetedLeftOuterJoin<MailInUidlTableInfo>

LeftOuterJoin_MsFilterMail_MailInFilterId

Generated left outer join from the primary key MailInFilterId on this table, to MsFilterMail.MailInFilterId.

Declaration
public TargetedLeftOuterJoin<MsFilterMailTableInfo> LeftOuterJoin_MsFilterMail_MailInFilterId { get; }
Property Value
Type Description
TargetedLeftOuterJoin<MsFilterMailTableInfo>

LeftOuterJoin_MsTrashbin_MailInFilterId

Generated left outer join from the primary key MailInFilterId on this table, to MsTrashbin.MailInFilterId.

Declaration
public TargetedLeftOuterJoin<MsTrashbinTableInfo> LeftOuterJoin_MsTrashbin_MailInFilterId { get; }
Property Value
Type Description
TargetedLeftOuterJoin<MsTrashbinTableInfo>

LeftOuterJoin_Ticket_FilterId

Generated left outer join from the primary key MailInFilterId on this table, to Ticket.FilterId.

Declaration
public TargetedLeftOuterJoin<TicketTableInfo> LeftOuterJoin_Ticket_FilterId { get; }
Property Value
Type Description
TargetedLeftOuterJoin<TicketTableInfo>

MailgunDsn

Field 'mailgun_dsn' in table 'mail_in_filter': Dictionary type Bool, .NET type: System.Int16

If this is set to 1, the route created in Mailgun will be set up to deliver emails of type auto-replies, system messsages etc

Declaration
public UInt16FieldInfo MailgunDsn { get; }
Property Value
Type Description
UInt16FieldInfo

MailInFilterId

Field 'id' in table 'mail_in_filter': Dictionary type PK, .NET type: System.Int32

The primary key (auto-incremented)

Declaration
public Int32FieldInfo MailInFilterId { get; }
Property Value
Type Description
Int32FieldInfo

NextCheck

Field 'next_check' in table 'mail_in_filter': Dictionary type DateTime, .NET type: System.DateTime

When this mailbox should be checked the next time.

Declaration
public DateTimeFieldInfo NextCheck { get; }
Property Value
Type Description
DateTimeFieldInfo

Noautoreply

Field 'noautoreply' in table 'mail_in_filter': Dictionary type Bool, .NET type: System.Int16

If set, then this mailbox should not send an autoreply.

Declaration
public UInt16FieldInfo Noautoreply { get; }
Property Value
Type Description
UInt16FieldInfo

NumSeqFailures

Field 'num_seq_failures' in table 'mail_in_filter': Dictionary type Int, .NET type: System.Int32

The number of sequential failures for this mailbox.

Declaration
public Int32FieldInfo NumSeqFailures { get; }
Property Value
Type Description
Int32FieldInfo

PopPassword

Field 'pop_password' in table 'mail_in_filter': Dictionary type String[256], .NET type: System.String

The password used to login.

Declaration
public StringFieldInfo PopPassword { get; }
Property Value
Type Description
StringFieldInfo

PopServer

Field 'pop_server' in table 'mail_in_filter': Dictionary type String[256], .NET type: System.String

The hostname/IP address of the server.

Declaration
public StringFieldInfo PopServer { get; }
Property Value
Type Description
StringFieldInfo

PopUser

Field 'pop_user' in table 'mail_in_filter': Dictionary type String[256], .NET type: System.String

The username used to login.

Declaration
public StringFieldInfo PopUser { get; }
Property Value
Type Description
StringFieldInfo

Priority

Field 'priority' in table 'mail_in_filter': Dictionary type FK, target: TicketPriority, .NET type: System.Int32

The id of the priority tickets are assigned when imported from this mailbox.

Declaration
public Int32FieldInfo Priority { get; }
Property Value
Type Description
Int32FieldInfo

Priority_InnerJoin_TicketPriority

Generated join from the foreign key Priority in this table, to its target table TicketPriorityTableInfo.

Declaration
public TargetedInnerJoin<TicketPriorityTableInfo> Priority_InnerJoin_TicketPriority { get; }
Property Value
Type Description
TargetedInnerJoin<TicketPriorityTableInfo>

ReplyTemplateId

Field 'reply_template_id' in table 'mail_in_filter': Dictionary type FK, target: ReplyTemplate, .NET type: System.Int32

ID of the reply template used on this mail box.

Declaration
public Int32FieldInfo ReplyTemplateId { get; }
Property Value
Type Description
Int32FieldInfo

ReplyTemplateId_InnerJoin_ReplyTemplate

Generated join from the foreign key ReplyTemplateId in this table, to its target table ReplyTemplateTableInfo.

Declaration
public TargetedInnerJoin<ReplyTemplateTableInfo> ReplyTemplateId_InnerJoin_ReplyTemplate { get; }
Property Value
Type Description
TargetedInnerJoin<ReplyTemplateTableInfo>

RuntimeDefinition

Definition of the table as described in the deployed runtime dictionary

Declaration
public static SoTable RuntimeDefinition { get; }
Property Value
Type Description
SoTable

ServerType

Field 'server_type' in table 'mail_in_filter': Dictionary type Enum, .NET type: MailboxType

Enum indicating the protocol to use (POP/IMAP).

Declaration
public MailboxTypeFieldInfo ServerType { get; }
Property Value
Type Description
MailboxTypeFieldInfo

Status

Field 'status' in table 'mail_in_filter': Dictionary type Enum, .NET type: System.Int16

Status indicated whether this mailbox is deleted or not.

Declaration
public UInt16FieldInfo Status { get; }
Property Value
Type Description
UInt16FieldInfo

TicketType

Field 'ticket_type' in table 'mail_in_filter': Dictionary type FK, target: TicketType, .NET type: System.Int32

Tickettype of the ticket

Declaration
public Int32FieldInfo TicketType { get; }
Property Value
Type Description
Int32FieldInfo

TicketType_InnerJoin_TicketType

Generated join from the foreign key TicketType in this table, to its target table TicketTypeTableInfo.

Declaration
public TargetedInnerJoin<TicketTypeTableInfo> TicketType_InnerJoin_TicketType { get; }
Property Value
Type Description
TargetedInnerJoin<TicketTypeTableInfo>

Implements

System.ICloneable

Extension Methods

EnumUtil.MapEnums<From, To>(From)