Class TicketAlertTableInfo

Table 'ticket_alert': This table will contain ticket escalation levels. A ticket will be escalated along a 'chain' of these levels.

Inheritance
Object
TableInfo
TicketAlertTableInfo
Implements
Inherited Members
Namespace: SuperOffice.CRM.Data
Assembly: SoDataBase.dll
Syntax
[DatabaseTable("ticket_alert")]
public class TicketAlertTableInfo : 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 TicketAlert in the database dictionary: ticket_alert

Declaration
public const string DictionaryTableName = "ticket_alert"
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 .

Properties

Action

Field 'action' in table 'ticket_alert': Dictionary type Int, .NET type: Int32

Bitmap indicating what should be done when escalating to this level.
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 .

AlertLevel

Field 'alert_level' in table 'ticket_alert': Dictionary type Short, .NET type: Int16

The alert level (strictly ascending number).
Declaration
public Int16FieldInfo AlertLevel { 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 .

AlertTimeout

Field 'alert_timeout' in table 'ticket_alert': Dictionary type Int, .NET type: Int32

The time (in minutes) before ticket is escalated to next level.
Declaration
public Int32FieldInfo AlertTimeout { 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 .

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 .

DelegateTo

Field 'delegate_to' in table 'ticket_alert': Dictionary type FK, target: Ejuser, .NET type: Int32

If ticket should be redelegated on escalation, this field contains the id of the target user.
Declaration
public Int32FieldInfo DelegateTo { 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 .

DelegateTo_InnerJoin_Ejuser

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

Declaration
public TargetedInnerJoin<EjuserTableInfo> DelegateTo_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 .

DictionaryTableNumber

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

EmailTo

Field 'email_to' in table 'ticket_alert': Dictionary type String[256], .NET type: String

If an email should be sent when escalating, this field will contain the recipient email address.
Declaration
public StringFieldInfo EmailTo { 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 .

LeftOuterJoin_Notify_TicketAlertId

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

Declaration
public TargetedLeftOuterJoin<NotifyTableInfo> LeftOuterJoin_Notify_TicketAlertId { 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 .

Priority

Field 'priority' in table 'ticket_alert': Dictionary type FK, target: TicketPriority, .NET type: Int32

The id of the ticket_priority entry this entry is connected to.
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 .

Priority_InnerJoin_TicketPriority

Generated join from the foreign key Priority in this table, to its target table TicketPriorityTableInfo.

Declaration
public TargetedInnerJoin<TicketPriorityTableInfo> Priority_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 .

ReplyTemplateIdCatmast

Field 'reply_template_id_catmast' in table 'ticket_alert': Dictionary type FK, target: ReplyTemplate, .NET type: Int32

Reference to the reply template used in this alert, for mail to category master
Declaration
public Int32FieldInfo ReplyTemplateIdCatmast { 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 .

ReplyTemplateIdCatmast_InnerJoin_ReplyTemplate

Generated join from the foreign key ReplyTemplateIdCatmast in this table, to its target table ReplyTemplateTableInfo.

Declaration
public TargetedInnerJoin<ReplyTemplateTableInfo> ReplyTemplateIdCatmast_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 .

ReplyTemplateIdCatmastSms

Field 'reply_template_id_catmast_sms' in table 'ticket_alert': Dictionary type FK, target: ReplyTemplate, .NET type: Int32

Reference to the reply template used in this alert, for sms to category master
Declaration
public Int32FieldInfo ReplyTemplateIdCatmastSms { 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 .

ReplyTemplateIdCatmastSms_InnerJoin_ReplyTemplate

Generated join from the foreign key ReplyTemplateIdCatmastSms in this table, to its target table ReplyTemplateTableInfo.

Declaration
public TargetedInnerJoin<ReplyTemplateTableInfo> ReplyTemplateIdCatmastSms_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 .

ReplyTemplateIdCustomer

Field 'reply_template_id_customer' in table 'ticket_alert': Dictionary type FK, target: ReplyTemplate, .NET type: Int32

Reference to the reply template used in this alert, for mail to customer
Declaration
public Int32FieldInfo ReplyTemplateIdCustomer { 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 .

ReplyTemplateIdCustomer_InnerJoin_ReplyTemplate

Generated join from the foreign key ReplyTemplateIdCustomer in this table, to its target table ReplyTemplateTableInfo.

Declaration
public TargetedInnerJoin<ReplyTemplateTableInfo> ReplyTemplateIdCustomer_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 .

ReplyTemplateIdEmail

Field 'reply_template_id_email' in table 'ticket_alert': Dictionary type FK, target: ReplyTemplate, .NET type: Int32

Reference to the reply template used in this alert, for mail to custom address
Declaration
public Int32FieldInfo ReplyTemplateIdEmail { 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 .

ReplyTemplateIdEmail_InnerJoin_ReplyTemplate

Generated join from the foreign key ReplyTemplateIdEmail in this table, to its target table ReplyTemplateTableInfo.

Declaration
public TargetedInnerJoin<ReplyTemplateTableInfo> ReplyTemplateIdEmail_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 .

ReplyTemplateIdSms

Field 'reply_template_id_sms' in table 'ticket_alert': Dictionary type FK, target: ReplyTemplate, .NET type: Int32

Reference to the reply template used in this alert, for sms to custom address
Declaration
public Int32FieldInfo ReplyTemplateIdSms { 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 .

ReplyTemplateIdSms_InnerJoin_ReplyTemplate

Generated join from the foreign key ReplyTemplateIdSms in this table, to its target table ReplyTemplateTableInfo.

Declaration
public TargetedInnerJoin<ReplyTemplateTableInfo> ReplyTemplateIdSms_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 .

ReplyTemplateIdUser

Field 'reply_template_id_user' in table 'ticket_alert': Dictionary type FK, target: ReplyTemplate, .NET type: Int32

Reference to the reply template used in this alert, for mail to owner of ticket
Declaration
public Int32FieldInfo ReplyTemplateIdUser { 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 .

ReplyTemplateIdUser_InnerJoin_ReplyTemplate

Generated join from the foreign key ReplyTemplateIdUser in this table, to its target table ReplyTemplateTableInfo.

Declaration
public TargetedInnerJoin<ReplyTemplateTableInfo> ReplyTemplateIdUser_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 .

ReplyTemplateIdUserSms

Field 'reply_template_id_user_sms' in table 'ticket_alert': Dictionary type FK, target: ReplyTemplate, .NET type: Int32

Reference to the reply template used in this alert, for sms to owner of ticket
Declaration
public Int32FieldInfo ReplyTemplateIdUserSms { 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 .

ReplyTemplateIdUserSms_InnerJoin_ReplyTemplate

Generated join from the foreign key ReplyTemplateIdUserSms in this table, to its target table ReplyTemplateTableInfo.

Declaration
public TargetedInnerJoin<ReplyTemplateTableInfo> ReplyTemplateIdUserSms_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 .

RtiCustomerSms

Field 'rti_customer_sms' in table 'ticket_alert': Dictionary type FK, target: ReplyTemplate, .NET type: Int32

Reference to the reply template used in this alert, for sms to customer
Declaration
public Int32FieldInfo RtiCustomerSms { 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 .

RtiCustomerSms_InnerJoin_ReplyTemplate

Generated join from the foreign key RtiCustomerSms in this table, to its target table ReplyTemplateTableInfo.

Declaration
public TargetedInnerJoin<ReplyTemplateTableInfo> RtiCustomerSms_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 .

RuntimeDefinition

Definition of the table as described in the deployed runtime dictionary

Declaration
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 .

ScriptId

Field 'script_id' in table 'ticket_alert': Dictionary type FK, target: Ejscript, .NET type: Int32

Script that can be executed then the ticket alert action occur.
Declaration
public Int32FieldInfo ScriptId { 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 .

ScriptId_InnerJoin_Ejscript

Generated join from the foreign key ScriptId in this table, to its target table EjscriptTableInfo.

Declaration
public TargetedInnerJoin<EjscriptTableInfo> ScriptId_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 .

SmsTo

Field 'sms_to' in table 'ticket_alert': Dictionary type String[256], .NET type: String

If an sms should be sent when escalating, this field will contain the recipient email address.
Declaration
public StringFieldInfo SmsTo { 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 .

TicketAlertId

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

The primary key (auto-incremented)
Declaration
public Int32FieldInfo TicketAlertId { 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 .

Implements

Extension Methods

EnumUtil.MapEnums<From, To>(From)