Class EjCategoryTableInfo
Table 'ej_category': This table contains categories, in which tickets are categorized. The categories are organized in a hierarchial manner.
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> |
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 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 |