Class MailInFilterTableInfo

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

Inheritance

object

TableInfo

MailInFilterTableInfo

Implements

ICloneable

Inherited Members

TableInfo.ToString()

TableInfo.RegisterFields(params FieldInfo[])

TableInfo.FieldInfoFromSoField(SoField)

TableInfo.Clone()

TableInfo.IsSameTable(TableInfo)

TableInfo.FindField(string)

TableInfo.ProtAll

TableInfo.UseNolockIfPossible

TableInfo.HashCheckFields

TableInfo.TableName

TableInfo.DbName

TableInfo.IsDictionaryTable

TableInfo.All

TableInfo.this[string]

TableInfo.PrimaryKeyField

object.Equals(object)

object.Equals(object, object)

object.ReferenceEquals(object, object)

object.GetHashCode()

object.GetType()

object.MemberwiseClone()

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 TablesInfo.GetMailInFilterInfo().

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
string

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 TablesInfo.GetMailInFilterInfo().

Properties

Address

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

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

Declaration

public StringFieldInfo Address { get; }

Property Value

Type	Description
StringFieldInfo

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 TablesInfo.GetMailInFilterInfo().

AiSuggestCategory

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

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

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 TablesInfo.GetMailInFilterInfo().

AiTextAnalysis

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

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

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 TablesInfo.GetMailInFilterInfo().

Autofaq

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

Whether to suggest FAQ entries for this email account or not

Declaration

public UInt16FieldInfo Autofaq { get; }

Property Value

Type	Description
UInt16FieldInfo

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 TablesInfo.GetMailInFilterInfo().

AutofaqKbCategory

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

The root folder for the auto faq search.

Declaration

public Int32FieldInfo AutofaqKbCategory { get; }

Property Value

Type	Description
Int32FieldInfo

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 TablesInfo.GetMailInFilterInfo().

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>

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 TablesInfo.GetMailInFilterInfo().

CategoryId

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

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

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 TablesInfo.GetMailInFilterInfo().

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>

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 TablesInfo.GetMailInFilterInfo().

Checkwait

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

How often (in minutes) to check this mailbox.

Declaration

public Int32FieldInfo Checkwait { get; }

Property Value

Type	Description
Int32FieldInfo

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 TablesInfo.GetMailInFilterInfo().

Definition

Definition of the table as described in the deployed runtime dictionary

Declaration

public override SoTable Definition { get; }

Property Value

Type	Description
SoTable

Overrides

TableInfo.Definition

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 TablesInfo.GetMailInFilterInfo().

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
int

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 TablesInfo.GetMailInFilterInfo().

Domain

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

The domain used to login.

Declaration

public StringFieldInfo Domain { get; }

Property Value

Type	Description
StringFieldInfo

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 TablesInfo.GetMailInFilterInfo().

ImportmailPid

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

The process id of the importMail instance processing this mailbox

Declaration

public Int32FieldInfo ImportmailPid { get; }

Property Value

Type	Description
Int32FieldInfo

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 TablesInfo.GetMailInFilterInfo().

KeepHeaders

Field 'keep_headers' in table 'mail_in_filter': Dictionary type String[256], .NET type: 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

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 TablesInfo.GetMailInFilterInfo().

LanguageId

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

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

Declaration

public Int32FieldInfo LanguageId { get; }

Property Value

Type	Description
Int32FieldInfo

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 TablesInfo.GetMailInFilterInfo().

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>

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 TablesInfo.GetMailInFilterInfo().

LastError

Field 'last_error' in table 'mail_in_filter': Dictionary type Clob, .NET type: 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

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 TablesInfo.GetMailInFilterInfo().

LastSuccess

Field 'last_success' in table 'mail_in_filter': Dictionary type DateTime, .NET type: 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

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 TablesInfo.GetMailInFilterInfo().

LastTry

Field 'last_try' in table 'mail_in_filter': Dictionary type DateTime, .NET type: 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

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 TablesInfo.GetMailInFilterInfo().

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>

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 TablesInfo.GetMailInFilterInfo().

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>

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 TablesInfo.GetMailInFilterInfo().

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>

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 TablesInfo.GetMailInFilterInfo().

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>

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 TablesInfo.GetMailInFilterInfo().

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>

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 TablesInfo.GetMailInFilterInfo().

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>

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 TablesInfo.GetMailInFilterInfo().

MailInFilterId

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

The primary key (auto-incremented)

Declaration

public Int32FieldInfo MailInFilterId { get; }

Property Value

Type	Description
Int32FieldInfo

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 TablesInfo.GetMailInFilterInfo().

MailgunDsn

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

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

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 TablesInfo.GetMailInFilterInfo().

NextCheck

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

When this mailbox should be checked the next time.

Declaration

public DateTimeFieldInfo NextCheck { get; }

Property Value

Type	Description
DateTimeFieldInfo

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 TablesInfo.GetMailInFilterInfo().

Noautoreply

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

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

Declaration

public UInt16FieldInfo Noautoreply { get; }

Property Value

Type	Description
UInt16FieldInfo

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 TablesInfo.GetMailInFilterInfo().

NumSeqFailures

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

The number of sequential failures for this mailbox.

Declaration

public Int32FieldInfo NumSeqFailures { get; }

Property Value

Type	Description
Int32FieldInfo

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 TablesInfo.GetMailInFilterInfo().

PopPassword

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

The password used to login.

Declaration

public StringFieldInfo PopPassword { get; }

Property Value

Type	Description
StringFieldInfo

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 TablesInfo.GetMailInFilterInfo().

PopServer

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

The hostname/IP address of the server.

Declaration

public StringFieldInfo PopServer { get; }

Property Value

Type	Description
StringFieldInfo

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 TablesInfo.GetMailInFilterInfo().

PopUser

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

The username used to login.

Declaration

public StringFieldInfo PopUser { get; }

Property Value

Type	Description
StringFieldInfo

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 TablesInfo.GetMailInFilterInfo().

Priority

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

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

Declaration

public Int32FieldInfo Priority { get; }

Property Value

Type	Description
Int32FieldInfo

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 TablesInfo.GetMailInFilterInfo().

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>

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 TablesInfo.GetMailInFilterInfo().

ReplyTemplateId

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

ID of the reply template used on this mail box.

Declaration

public Int32FieldInfo ReplyTemplateId { get; }

Property Value

Type	Description
Int32FieldInfo

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 TablesInfo.GetMailInFilterInfo().

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>

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 TablesInfo.GetMailInFilterInfo().

RuntimeDefinition

Definition of the table as described in the deployed runtime dictionary

Declaration

[Obsolete("Use instance property Definition or static member DictionaryTableNumber", true)]
public static SoTable RuntimeDefinition { get; }

Property Value

Type	Description
SoTable

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 TablesInfo.GetMailInFilterInfo().

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

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 TablesInfo.GetMailInFilterInfo().

Status

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

Status indicated whether this mailbox is deleted or not.

Declaration

public UInt16FieldInfo Status { get; }

Property Value

Type	Description
UInt16FieldInfo

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 TablesInfo.GetMailInFilterInfo().

TicketType

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

Tickettype of the ticket

Declaration

public Int32FieldInfo TicketType { get; }

Property Value

Type	Description
Int32FieldInfo

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 TablesInfo.GetMailInFilterInfo().

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>

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 TablesInfo.GetMailInFilterInfo().

Implements

ICloneable

Extension Methods

EnumUtil.MapEnums<From, To>(From)

Converters.MapEnums<From, To>(From)