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 TablesInfo.GetTicketAlertInfo().

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 TablesInfo.GetTicketAlertInfo().

Properties

Action

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

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 TablesInfo.GetTicketAlertInfo().

AlertLevel

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

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 TablesInfo.GetTicketAlertInfo().

AlertTimeout

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

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 TablesInfo.GetTicketAlertInfo().

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.GetTicketAlertInfo().

DelegateTo

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

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 TablesInfo.GetTicketAlertInfo().

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 TablesInfo.GetTicketAlertInfo().

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
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.GetTicketAlertInfo().

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 TablesInfo.GetTicketAlertInfo().

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 TablesInfo.GetTicketAlertInfo().

Priority

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

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 TablesInfo.GetTicketAlertInfo().

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 TablesInfo.GetTicketAlertInfo().

ReplyTemplateIdCatmast

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

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 TablesInfo.GetTicketAlertInfo().

ReplyTemplateIdCatmastSms

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

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 TablesInfo.GetTicketAlertInfo().

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 TablesInfo.GetTicketAlertInfo().

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 TablesInfo.GetTicketAlertInfo().

ReplyTemplateIdCustomer

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

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 TablesInfo.GetTicketAlertInfo().

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 TablesInfo.GetTicketAlertInfo().

ReplyTemplateIdEmail

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

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 TablesInfo.GetTicketAlertInfo().

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 TablesInfo.GetTicketAlertInfo().

ReplyTemplateIdSms

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

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 TablesInfo.GetTicketAlertInfo().

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 TablesInfo.GetTicketAlertInfo().

ReplyTemplateIdUser

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

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 TablesInfo.GetTicketAlertInfo().

ReplyTemplateIdUserSms

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

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 TablesInfo.GetTicketAlertInfo().

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 TablesInfo.GetTicketAlertInfo().

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 TablesInfo.GetTicketAlertInfo().

RtiCustomerSms

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

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 TablesInfo.GetTicketAlertInfo().

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 TablesInfo.GetTicketAlertInfo().

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.GetTicketAlertInfo().

ScriptId

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

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 TablesInfo.GetTicketAlertInfo().

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 TablesInfo.GetTicketAlertInfo().

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 TablesInfo.GetTicketAlertInfo().

TicketAlertId

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

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 TablesInfo.GetTicketAlertInfo().

Implements

Extension Methods