Class MsFilterTableInfo

Table 'ms_filter': This table contains email filters. These are the filters allowing you to do advanced parsing of incomming emails.

Inheritance

object

TableInfo

MsFilterTableInfo

Implements

ICloneable

Inherited Members

TableInfo.ToString()

TableInfo.RegisterFields(params FieldInfo[])

TableInfo.FieldInfoFromSoField(SoField)

TableInfo.Clone()

TableInfo.IsSameTable(TableInfo)

TableInfo.FindField(string)

TableInfo.ProtAll

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("ms_filter")]
public class MsFilterTableInfo : 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.GetMsFilterInfo().

Fields

DictionaryTableName

Conceptual name of table MsFilter in the database dictionary: ms_filter

Declaration

public const string DictionaryTableName = "ms_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.GetMsFilterInfo().

Properties

Action

Field 'action' in table 'ms_filter': Dictionary type Int, .NET type: int

A bitmask representing the actions that should be performed if this filter is executed.

Declaration

public Int32FieldInfo Action { 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.GetMsFilterInfo().

ActionWhen

Field 'action_when' in table 'ms_filter': Dictionary type Enum, .NET type: short

Enum indicating what should trigger this filter.

Declaration

public UInt16FieldInfo ActionWhen { 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.GetMsFilterInfo().

AutofaqReplyCategory

Field 'autofaq_reply_category' in table 'ms_filter': Dictionary type FK, target: ReplyTemplateFolder, .NET type: int

The root folder for the auto faq search.

Declaration

public Int32FieldInfo AutofaqReplyCategory { 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.GetMsFilterInfo().

AutofaqReplyCategory_InnerJoin_ReplyTemplateFolder

Generated join from the foreign key AutofaqReplyCategory in this table, to its target table ReplyTemplateFolderTableInfo.

Declaration

public TargetedInnerJoin<ReplyTemplateFolderTableInfo> AutofaqReplyCategory_InnerJoin_ReplyTemplateFolder { get; }

Property Value

Type	Description
TargetedInnerJoin<ReplyTemplateFolderTableInfo>

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.GetMsFilterInfo().

BodyTemplate

Field 'body_template' in table 'ms_filter': Dictionary type FK, target: ReplyTemplate, .NET type: int

The template to use for the body of the message.

Declaration

public Int32FieldInfo BodyTemplate { 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.GetMsFilterInfo().

BodyTemplate_InnerJoin_ReplyTemplate

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

Declaration

public TargetedInnerJoin<ReplyTemplateTableInfo> BodyTemplate_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.GetMsFilterInfo().

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.GetMsFilterInfo().

Description

Field 'description' in table 'ms_filter': Dictionary type String[256], .NET type: string

A description for this filter.

Declaration

public StringFieldInfo Description { 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.GetMsFilterInfo().

DictionaryTableNumber

Table number for table MsFilter 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.GetMsFilterInfo().

Ejscript

Field 'ejscript' in table 'ms_filter': Dictionary type FK, target: Ejscript, .NET type: int

The reference to the ejscript to execute for this filter.

Declaration

public Int32FieldInfo Ejscript { 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.GetMsFilterInfo().

Ejscript_InnerJoin_Ejscript

Generated join from the foreign key Ejscript in this table, to its target table EjscriptTableInfo.

Declaration

public TargetedInnerJoin<EjscriptTableInfo> Ejscript_InnerJoin_Ejscript { get; }

Property Value

Type	Description
TargetedInnerJoin<EjscriptTableInfo>

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.GetMsFilterInfo().

Flags

Field 'flags' in table 'ms_filter': Dictionary type Int, .NET type: int

Flags

Declaration

public Int32FieldInfo Flags { 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.GetMsFilterInfo().

ForwardTo

Field 'forward_to' in table 'ms_filter': Dictionary type String[256], .NET type: string

An email address to forward the ticket to.

Declaration

public StringFieldInfo ForwardTo { 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.GetMsFilterInfo().

LeftOuterJoin_MsFilterMail_MailSorterId

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

Declaration

public TargetedLeftOuterJoin<MsFilterMailTableInfo> LeftOuterJoin_MsFilterMail_MailSorterId { 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.GetMsFilterInfo().

LeftOuterJoin_MsSubstitute_MsFilterId

Generated left outer join from the primary key MsFilterId on this table, to MsSubstitute.MsFilterId.

Declaration

public TargetedLeftOuterJoin<MsSubstituteTableInfo> LeftOuterJoin_MsSubstitute_MsFilterId { get; }

Property Value

Type	Description
TargetedLeftOuterJoin<MsSubstituteTableInfo>

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.GetMsFilterInfo().

LeftOuterJoin_MsTrashbin_MailSorterId

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

Declaration

public TargetedLeftOuterJoin<MsTrashbinTableInfo> LeftOuterJoin_MsTrashbin_MailSorterId { 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.GetMsFilterInfo().

MsFilterId

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

The primary key (auto-incremented)

Declaration

public Int32FieldInfo MsFilterId { 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.GetMsFilterInfo().

NewCategory

Field 'new_category' in table 'ms_filter': Dictionary type FK, target: EjCategory, .NET type: int

The id of the category to set for the ticket if specified by action.

Declaration

public Int32FieldInfo NewCategory { 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.GetMsFilterInfo().

NewCategory_InnerJoin_EjCategory

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

Declaration

public TargetedInnerJoin<EjCategoryTableInfo> NewCategory_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.GetMsFilterInfo().

NewOwner

Field 'new_owner' in table 'ms_filter': Dictionary type FK, target: Ejuser, .NET type: int

The id of the owner to set for the ticket if specified by action.

Declaration

public Int32FieldInfo NewOwner { 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.GetMsFilterInfo().

NewOwner_InnerJoin_Ejuser

Generated join from the foreign key NewOwner in this table, to its target table EjuserTableInfo.

Declaration

public TargetedInnerJoin<EjuserTableInfo> NewOwner_InnerJoin_Ejuser { get; }

Property Value

Type	Description
TargetedInnerJoin<EjuserTableInfo>

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.GetMsFilterInfo().

NewPriority

Field 'new_priority' in table 'ms_filter': Dictionary type FK, target: TicketPriority, .NET type: int

The id of the priority to set for the ticket if specified by action.

Declaration

public Int32FieldInfo NewPriority { 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.GetMsFilterInfo().

NewPriority_InnerJoin_TicketPriority

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

Declaration

public TargetedInnerJoin<TicketPriorityTableInfo> NewPriority_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.GetMsFilterInfo().

NewSlevel

Field 'new_slevel' in table 'ms_filter': Dictionary type Int, .NET type: int

The security level to set for the ticket if specified by action.

Declaration

public Int32FieldInfo NewSlevel { 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.GetMsFilterInfo().

NewTags

Field 'new_tags' in table 'ms_filter': Dictionary type FKArray, .NET type: int

The tags to set for tickets modified by this filter

Declaration

public Int32ArrayFieldInfo NewTags { get; }

Property Value

Type	Description
Int32ArrayFieldInfo

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.GetMsFilterInfo().

NewTicketType

Field 'new_ticket_type' in table 'ms_filter': Dictionary type FK, target: TicketType, .NET type: int

Tickettype of the ticket

Declaration

public Int32FieldInfo NewTicketType { 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.GetMsFilterInfo().

NewTicketType_InnerJoin_TicketType

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

Declaration

public TargetedInnerJoin<TicketTypeTableInfo> NewTicketType_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.GetMsFilterInfo().

ParseMode

Field 'parse_mode' in table 'ms_filter': Dictionary type Short, .NET type: short

If automatic parsing this column indicate mode

Declaration

public Int16FieldInfo ParseMode { get; }

Property Value

Type	Description
Int16FieldInfo

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.GetMsFilterInfo().

Priority

Field 'priority' in table 'ms_filter': Dictionary type Int, .NET type: int

A number indicating the priority for this filter (0..10).

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.GetMsFilterInfo().

ReplyTemplate

Field 'reply_template' in table 'ms_filter': Dictionary type FK, target: ReplyTemplate, .NET type: int

The id of the template to use as the reply template if specified by action.

Declaration

public Int32FieldInfo ReplyTemplate { 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.GetMsFilterInfo().

ReplyTemplate_InnerJoin_ReplyTemplate

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

Declaration

public TargetedInnerJoin<ReplyTemplateTableInfo> ReplyTemplate_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.GetMsFilterInfo().

ReplyTo

Field 'reply_to' in table 'ms_filter': Dictionary type String[256], .NET type: string

The email address to reply to.

Declaration

public StringFieldInfo ReplyTo { 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.GetMsFilterInfo().

ReplyToSms

Field 'reply_to_sms' in table 'ms_filter': Dictionary type String[256], .NET type: string

The SMS number to reply to.

Declaration

public StringFieldInfo ReplyToSms { 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.GetMsFilterInfo().

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.GetMsFilterInfo().

SearchLocation

Field 'search_location' in table 'ms_filter': Dictionary type Enum, .NET type: short

Enum indicating where to search.

Declaration

public UInt16FieldInfo SearchLocation { 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.GetMsFilterInfo().

SearchString

Field 'search_string' in table 'ms_filter': Dictionary type String[256], .NET type: string

The string to search for.

Declaration

public StringFieldInfo SearchString { 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.GetMsFilterInfo().

SearchString2

Field 'search_string2' in table 'ms_filter': Dictionary type String[256], .NET type: string

A second string to search for. Only used if not empty.

Declaration

public StringFieldInfo SearchString2 { 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.GetMsFilterInfo().

Implements

ICloneable

Extension Methods

EnumUtil.MapEnums<From, To>(From)

Converters.MapEnums<From, To>(From)