Class TicketAlertTableInfo
Table 'ticket_alert': This table will contain ticket escalation levels. A ticket will be escalated along a 'chain' of these levels.
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 masterDeclaration
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 masterDeclaration
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 customerDeclaration
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 addressDeclaration
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 addressDeclaration
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 ticketDeclaration
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 ticketDeclaration
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 customerDeclaration
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