Class MailInFilterTableInfo
Table 'mail_in_filter': This table contains entries for the mailboxes the eJournal system is fetching mail from (POP3 or IMAP).
Implements
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> |