Show / Hide Table of Contents

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