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 TablesInfo.GetEjCategoryInfo().
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 |
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.GetEjCategoryInfo().
Properties
AssignmentLag
Field 'assignment_lag' in table 'ej_category': Dictionary type Int, .NET type: int
Number of minutes we shall override the assignment if a customer sends consecutive messages to this categoryDeclaration
public Int32FieldInfo AssignmentLag { 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.GetEjCategoryInfo().
CategoryMaster
Field 'category_master' in table 'ej_category': Dictionary type FK, target: Ejuser, .NET type: int
The user associated with this category.Declaration
public Int32FieldInfo CategoryMaster { 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.GetEjCategoryInfo().
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> |
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.GetEjCategoryInfo().
ClosingStatus
Field 'closing_status' in table 'ej_category': Dictionary type FK, target: TicketStatus, .NET type: int
Default status for new tickets, if 0 then there is a fallback to a user-dependent valueDeclaration
public Int32FieldInfo ClosingStatus { 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.GetEjCategoryInfo().
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> |
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.GetEjCategoryInfo().
Definition
Definition of the table as described in the deployed runtime dictionary
Declaration
public override SoTable Definition { get; }
Property Value
Type | Description |
---|---|
SoTable |
Overrides
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.GetEjCategoryInfo().
DelegateCounter
Field 'delegate_counter' in table 'ej_category': Dictionary type Int, .NET type: int
A delegate counter, incremented by 1 for every delegationDeclaration
public Int32FieldInfo DelegateCounter { 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.GetEjCategoryInfo().
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 |
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.GetEjCategoryInfo().
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 |
---|---|
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.GetEjCategoryInfo().
EjCategoryId
Field 'id' in table 'ej_category': Dictionary type PK, .NET type: int
The primary key (auto-incremented)Declaration
public Int32FieldInfo EjCategoryId { 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.GetEjCategoryInfo().
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 |
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.GetEjCategoryInfo().
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 |
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.GetEjCategoryInfo().
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 |
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.GetEjCategoryInfo().
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> |
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.GetEjCategoryInfo().
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> |
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.GetEjCategoryInfo().
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> |
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.GetEjCategoryInfo().
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> |
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.GetEjCategoryInfo().
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> |
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.GetEjCategoryInfo().
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> |
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.GetEjCategoryInfo().
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> |
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.GetEjCategoryInfo().
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> |
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.GetEjCategoryInfo().
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> |
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.GetEjCategoryInfo().
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> |
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.GetEjCategoryInfo().
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> |
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.GetEjCategoryInfo().
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> |
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.GetEjCategoryInfo().
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> |
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.GetEjCategoryInfo().
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> |
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.GetEjCategoryInfo().
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> |
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.GetEjCategoryInfo().
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> |
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.GetEjCategoryInfo().
MsgClosingStatus
Field 'msg_closing_status' in table 'ej_category': Dictionary type FK, target: TicketStatus, .NET type: int
Default status for new messages, if 0 then there is a fallback to a user-dependent valueDeclaration
public Int32FieldInfo MsgClosingStatus { 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.GetEjCategoryInfo().
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> |
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.GetEjCategoryInfo().
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 |
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.GetEjCategoryInfo().
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 |
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.GetEjCategoryInfo().
ParentId
Field 'parent_id' in table 'ej_category': Dictionary type FK, target: EjCategory, .NET type: int
The parent category for this category. -1 if this is a toplevel category.Declaration
public Int32FieldInfo ParentId { 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.GetEjCategoryInfo().
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> |
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.GetEjCategoryInfo().
ReplyTemplate
Field 'reply_template' in table 'ej_category': Dictionary type FK, target: ReplyTemplate, .NET type: int
Reply template to merge with messages posted in this categoryDeclaration
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.GetEjCategoryInfo().
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.GetEjCategoryInfo().
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.GetEjCategoryInfo().