Class EjCategoryTableInfo

Table 'ej_category': This table contains categories, in which tickets are categorized. The categories are organized in a hierarchial manner.

Inheritance

System.Object

TableInfo

EjCategoryTableInfo

Implements

System.ICloneable

Inherited Members

TableInfo.ToString()

TableInfo.RegisterFields(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.Item[String]

TableInfo.PrimaryKeyField

Namespace: SuperOffice.CRM.Data

Assembly: SoDataBase.dll

Syntax

[DatabaseTable("ej_category")]
public class EjCategoryTableInfo : 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 EjCategory in the database dictionary: ej_category

Declaration

public const string DictionaryTableName = "ej_category"

Field Value

Type	Description
System.String

Properties

AssignmentLag

Field 'assignment_lag' in table 'ej_category': Dictionary type Int, .NET type: System.Int32

Number of minutes we shall override the assignment if a customer sends consecutive messages to this category

Declaration

public Int32FieldInfo AssignmentLag { get; }

Property Value

Type	Description
Int32FieldInfo

CategoryMaster

Field 'category_master' in table 'ej_category': Dictionary type FK, target: Ejuser, .NET type: System.Int32

The user associated with this category.

Declaration

public Int32FieldInfo CategoryMaster { get; }

Property Value

Type	Description
Int32FieldInfo

CategoryMaster_InnerJoin_Ejuser

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

Declaration

public TargetedInnerJoin<EjuserTableInfo> CategoryMaster_InnerJoin_Ejuser { get; }

Property Value

Type	Description
TargetedInnerJoin<EjuserTableInfo>

ClosingStatus

Field 'closing_status' in table 'ej_category': Dictionary type FK, target: TicketStatus, .NET type: System.Int32

Default status for new tickets, if 0 then there is a fallback to a user-dependent value

Declaration

public Int32FieldInfo ClosingStatus { get; }

Property Value

Type	Description
Int32FieldInfo

ClosingStatus_InnerJoin_TicketStatus

Generated join from the foreign key ClosingStatus in this table, to its target table TicketStatusTableInfo.

Declaration

public TargetedInnerJoin<TicketStatusTableInfo> ClosingStatus_InnerJoin_TicketStatus { get; }

Property Value

Type	Description
TargetedInnerJoin<TicketStatusTableInfo>

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

DelegateCounter

Field 'delegate_counter' in table 'ej_category': Dictionary type Int, .NET type: System.Int32

A delegate counter, incremented by 1 for every delegation

Declaration

public Int32FieldInfo DelegateCounter { get; }

Property Value

Type	Description
Int32FieldInfo

DelegateMethod

Field 'delegate_method' in table 'ej_category': Dictionary type Enum, .NET type: TicketCategoryDelegateMethod

An integer indicating the delegation method for this category.

Declaration

public TicketCategoryDelegateMethodFieldInfo DelegateMethod { get; }

Property Value

Type	Description
TicketCategoryDelegateMethodFieldInfo

DictionaryTableNumber

Table number for table EjCategory 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

EjCategoryId

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

The primary key (auto-incremented)

Declaration

public Int32FieldInfo EjCategoryId { get; }

Property Value

Type	Description
Int32FieldInfo

ExternalName

Field 'external_name' in table 'ej_category': Dictionary type String[256], .NET type: System.String

The external name for this category, used for the customer frontend.

Declaration

public StringFieldInfo ExternalName { get; }

Property Value

Type	Description
StringFieldInfo

Flags

Field 'flags' in table 'ej_category': Dictionary type Enum, .NET type: TicketCategoryFlags

A bitmask representing flags for this category.

Declaration

public TicketCategoryFlagsFieldInfo Flags { get; }

Property Value

Type	Description
TicketCategoryFlagsFieldInfo

Fullname

Field 'fullname' in table 'ej_category': Dictionary type String[256], .NET type: System.String

The fullname (compiled from parents' names) for this category. E.g. 'norway/product A/support'.

Declaration

public StringFieldInfo Fullname { get; }

Property Value

Type	Description
StringFieldInfo

LeftOuterJoin_CategoryMembership_CategoryId

Generated left outer join from the primary key EjCategoryId on this table, to CategoryMembership.CategoryId.

Declaration

public TargetedLeftOuterJoin<CategoryMembershipTableInfo> LeftOuterJoin_CategoryMembership_CategoryId { get; }

Property Value

Type	Description
TargetedLeftOuterJoin<CategoryMembershipTableInfo>

LeftOuterJoin_ChatTopic_CategoryId

Generated left outer join from the primary key EjCategoryId on this table, to ChatTopic.CategoryId.

Declaration

public TargetedLeftOuterJoin<ChatTopicTableInfo> LeftOuterJoin_ChatTopic_CategoryId { get; }

Property Value

Type	Description
TargetedLeftOuterJoin<ChatTopicTableInfo>

LeftOuterJoin_CustCategory_CategoryId

Generated left outer join from the primary key EjCategoryId on this table, to CustCategory.CategoryId.

Declaration

public TargetedLeftOuterJoin<CustCategoryTableInfo> LeftOuterJoin_CustCategory_CategoryId { get; }

Property Value

Type	Description
TargetedLeftOuterJoin<CustCategoryTableInfo>

LeftOuterJoin_EjCategoryGroupLink_EjCategoryId

Generated left outer join from the primary key EjCategoryId on this table, to EjCategoryGroupLink.EjCategoryId.

Declaration

public TargetedLeftOuterJoin<EjCategoryGroupLinkTableInfo> LeftOuterJoin_EjCategoryGroupLink_EjCategoryId { get; }

Property Value

Type	Description
TargetedLeftOuterJoin<EjCategoryGroupLinkTableInfo>

LeftOuterJoin_Ejuser_DefaultCategory

Generated left outer join from the primary key EjCategoryId on this table, to Ejuser.DefaultCategory.

Declaration

public TargetedLeftOuterJoin<EjuserTableInfo> LeftOuterJoin_Ejuser_DefaultCategory { get; }

Property Value

Type	Description
TargetedLeftOuterJoin<EjuserTableInfo>

LeftOuterJoin_Ejuser_LastCategory

Generated left outer join from the primary key EjCategoryId on this table, to Ejuser.LastCategory.

Declaration

public TargetedLeftOuterJoin<EjuserTableInfo> LeftOuterJoin_Ejuser_LastCategory { get; }

Property Value

Type	Description
TargetedLeftOuterJoin<EjuserTableInfo>

LeftOuterJoin_KbGroup_ParentId

Generated left outer join from the primary key EjCategoryId on this table, to KbGroup.ParentId.

Declaration

public TargetedLeftOuterJoin<KbGroupTableInfo> LeftOuterJoin_KbGroup_ParentId { get; }

Property Value

Type	Description
TargetedLeftOuterJoin<KbGroupTableInfo>

LeftOuterJoin_MailInFilter_CategoryId

Generated left outer join from the primary key EjCategoryId on this table, to MailInFilter.CategoryId.

Declaration

public TargetedLeftOuterJoin<MailInFilterTableInfo> LeftOuterJoin_MailInFilter_CategoryId { get; }

Property Value

Type	Description
TargetedLeftOuterJoin<MailInFilterTableInfo>

LeftOuterJoin_MsFilter_NewCategory

Generated left outer join from the primary key EjCategoryId on this table, to MsFilter.NewCategory.

Declaration

public TargetedLeftOuterJoin<MsFilterTableInfo> LeftOuterJoin_MsFilter_NewCategory { get; }

Property Value

Type	Description
TargetedLeftOuterJoin<MsFilterTableInfo>

LeftOuterJoin_Notify_CategoryId

Generated left outer join from the primary key EjCategoryId on this table, to Notify.CategoryId.

Declaration

public TargetedLeftOuterJoin<NotifyTableInfo> LeftOuterJoin_Notify_CategoryId { get; }

Property Value

Type	Description
TargetedLeftOuterJoin<NotifyTableInfo>

LeftOuterJoin_RoleCategory_Category

Generated left outer join from the primary key EjCategoryId on this table, to RoleCategory.Category.

Declaration

public TargetedLeftOuterJoin<RoleCategoryTableInfo> LeftOuterJoin_RoleCategory_Category { get; }

Property Value

Type	Description
TargetedLeftOuterJoin<RoleCategoryTableInfo>

LeftOuterJoin_SLink_TicketCategory

Generated left outer join from the primary key EjCategoryId on this table, to SLink.TicketCategory.

Declaration

public TargetedLeftOuterJoin<SLinkTableInfo> LeftOuterJoin_SLink_TicketCategory { get; }

Property Value

Type	Description
TargetedLeftOuterJoin<SLinkTableInfo>

LeftOuterJoin_Ticket_Category

Generated left outer join from the primary key EjCategoryId on this table, to Ticket.Category.

Declaration

public TargetedLeftOuterJoin<TicketTableInfo> LeftOuterJoin_Ticket_Category { get; }

Property Value

Type	Description
TargetedLeftOuterJoin<TicketTableInfo>

LeftOuterJoin_Ticket_OrigCategory

Generated left outer join from the primary key EjCategoryId on this table, to Ticket.OrigCategory.

Declaration

public TargetedLeftOuterJoin<TicketTableInfo> LeftOuterJoin_Ticket_OrigCategory { get; }

Property Value

Type	Description
TargetedLeftOuterJoin<TicketTableInfo>

LeftOuterJoin_Ticket_OrigHumanCategoryId

Generated left outer join from the primary key EjCategoryId on this table, to Ticket.OrigHumanCategoryId.

Declaration

public TargetedLeftOuterJoin<TicketTableInfo> LeftOuterJoin_Ticket_OrigHumanCategoryId { get; }

Property Value

Type	Description
TargetedLeftOuterJoin<TicketTableInfo>

LeftOuterJoin_Ticket_SuggestedCategoryId

Generated left outer join from the primary key EjCategoryId on this table, to Ticket.SuggestedCategoryId.

Declaration

public TargetedLeftOuterJoin<TicketTableInfo> LeftOuterJoin_Ticket_SuggestedCategoryId { get; }

Property Value

Type	Description
TargetedLeftOuterJoin<TicketTableInfo>

MsgClosingStatus

Field 'msg_closing_status' in table 'ej_category': Dictionary type FK, target: TicketStatus, .NET type: System.Int32

Default status for new messages, if 0 then there is a fallback to a user-dependent value

Declaration

public Int32FieldInfo MsgClosingStatus { get; }

Property Value

Type	Description
Int32FieldInfo

MsgClosingStatus_InnerJoin_TicketStatus

Generated join from the foreign key MsgClosingStatus in this table, to its target table TicketStatusTableInfo.

Declaration

public TargetedInnerJoin<TicketStatusTableInfo> MsgClosingStatus_InnerJoin_TicketStatus { get; }

Property Value

Type	Description
TargetedInnerJoin<TicketStatusTableInfo>

Name

Field 'name' in table 'ej_category': Dictionary type String[65], .NET type: System.String

The (short) name of this category. E.g. 'support'.

Declaration

public StringFieldInfo Name { get; }

Property Value

Type	Description
StringFieldInfo

NotificationEmail

Field 'notification_email' in table 'ej_category': Dictionary type String[2048], .NET type: System.String

Comma separated list of addresses to notify when requests are redelegated to (unassigned) in this category.

Declaration

public StringFieldInfo NotificationEmail { get; }

Property Value

Type	Description
StringFieldInfo

ParentId

Field 'parent_id' in table 'ej_category': Dictionary type FK, target: EjCategory, .NET type: System.Int32

The parent category for this category. -1 if this is a toplevel category.

Declaration

public Int32FieldInfo ParentId { get; }

Property Value

Type	Description
Int32FieldInfo

ParentId_InnerJoin_EjCategory

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

Declaration

public TargetedInnerJoin<EjCategoryTableInfo> ParentId_InnerJoin_EjCategory { get; }

Property Value

Type	Description
TargetedInnerJoin<EjCategoryTableInfo>

ReplyTemplate

Field 'reply_template' in table 'ej_category': Dictionary type FK, target: ReplyTemplate, .NET type: System.Int32

Reply template to merge with messages posted in this category

Declaration

public Int32FieldInfo ReplyTemplate { get; }

Property Value

Type	Description
Int32FieldInfo

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>

RuntimeDefinition

Definition of the table as described in the deployed runtime dictionary

Declaration

public static SoTable RuntimeDefinition { get; }

Property Value

Type	Description
SoTable

Implements

System.ICloneable

Extension Methods

EnumUtil.MapEnums<From, To>(From)

Converters.MapEnums<From, To>(From)