Class EjCategoryTableInfo

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

Inheritance
Object
TableInfo
EjCategoryTableInfo
Implements
Inherited Members
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
String

Properties

AssignmentLag

Field 'assignment_lag' in table 'ej_category': Dictionary type Int, .NET type: 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, .NET type: 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 Enum, .NET type: TicketCategoryClosingStatus

An integer indicating if new requests should have the 'close request' in this category checked as default, or if the users preferences should be selected.

Declaration
public TicketCategoryClosingStatusFieldInfo ClosingStatus { get; }
Property Value
Type Description
TicketCategoryClosingStatusFieldInfo

Definition

Definition of the table as described in the deployed runtime dictionary

Declaration
public override SoTable Definition { get; }
Property Value
Type Description
SoTable
Overrides

DelegateCounter

Field 'delegate_counter' in table 'ej_category': Dictionary type Int, .NET type: 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
Int32

EjCategoryId

Field 'id' in table 'ej_category': Dictionary type PK, .NET type: 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: 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: 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>

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>

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 Enum, .NET type: TicketCategoryClosingStatus

An integer indicating if new messages should have the 'close request' in this category checked as default, or if the users preferences should be selected.

Declaration
public TicketCategoryClosingStatusFieldInfo MsgClosingStatus { get; }
Property Value
Type Description
TicketCategoryClosingStatusFieldInfo

Name

Field 'name' in table 'ej_category': Dictionary type String[65], .NET type: 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: 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, .NET type: 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, .NET type: 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
[Obsolete("Use instance property Definition or static member DictionaryTableNumber", true)]
public static SoTable RuntimeDefinition { get; }
Property Value
Type Description
SoTable

Implements

Extension Methods

EnumUtil.MapEnums<From, To>(From)