Class TicketLogActionTableInfo

Table 'ticket_log_action': This table contains actions for the tickets.

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

Declaration
public const string DictionaryTableName = "ticket_log_action"
Field Value
Type Description
System.String

Properties

CustomerId

Field 'customer_id' in table 'ticket_log_action': Dictionary type FK, target: Person, .NET type: System.Int32

The id of the customer this entry is connected to.

Declaration
public Int32FieldInfo CustomerId { get; }
Property Value
Type Description
Int32FieldInfo

CustomerId_InnerJoin_Person

Generated join from the foreign key CustomerId in this table, to its target table PersonTableInfo.

Declaration
public TargetedInnerJoin<PersonTableInfo> CustomerId_InnerJoin_Person { get; }
Property Value
Type Description
TargetedInnerJoin<PersonTableInfo>

Definition

Definition of the table as described in the deployed runtime dictionary

Declaration
public override SoTable Definition { get; }
Property Value
Type Description
SoTable
Overrides

Description

Field 'description' in table 'ticket_log_action': Dictionary type String[256], .NET type: System.String

Action description, only used by customer actions like ejscript

Declaration
public StringFieldInfo Description { get; }
Property Value
Type Description
StringFieldInfo

Details

Field 'details' in table 'ticket_log_action': Dictionary type Clob, .NET type: System.String

Field for storing details of the log action as e.g. JSON

Declaration
public StringFieldInfo Details { get; }
Property Value
Type Description
StringFieldInfo

DictionaryTableNumber

Table number for table TicketLogAction 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
System.Int32

LeftOuterJoin_TicketLogChange_ActionId

Generated left outer join from the primary key TicketLogActionId on this table, to TicketLogChange.ActionId.

Declaration
public TargetedLeftOuterJoin<TicketLogChangeTableInfo> LeftOuterJoin_TicketLogChange_ActionId { get; }
Property Value
Type Description
TargetedLeftOuterJoin<TicketLogChangeTableInfo>

LogAction

Field 'log_action' in table 'ticket_log_action': Dictionary type Enum, .NET type: TicketLogAction

An enum indicating what kind of log-entry this is.

Declaration
public TicketLogActionFieldInfo LogAction { get; }
Property Value
Type Description
TicketLogActionFieldInfo

LogWhen

Field 'log_when' in table 'ticket_log_action': Dictionary type DateTime, .NET type: System.DateTime

When the action occured.

Declaration
public DateTimeFieldInfo LogWhen { get; }
Property Value
Type Description
DateTimeFieldInfo

MessageId

Field 'message_id' in table 'ticket_log_action': Dictionary type FK, target: EjMessage, .NET type: System.Int32

If this entry is connected to a message, then this is a message change log entry.

Declaration
public Int32FieldInfo MessageId { get; }
Property Value
Type Description
Int32FieldInfo

MessageId_InnerJoin_EjMessage

Generated join from the foreign key MessageId in this table, to its target table EjMessageTableInfo.

Declaration
public TargetedInnerJoin<EjMessageTableInfo> MessageId_InnerJoin_EjMessage { get; }
Property Value
Type Description
TargetedInnerJoin<EjMessageTableInfo>

OrgTicketId

Field 'org_ticket_id' in table 'ticket_log_action': Dictionary type FK, target: Ticket, .NET type: System.Int32

The id of the orignal ticket this entry was connected to.

Declaration
public Int32FieldInfo OrgTicketId { get; }
Property Value
Type Description
Int32FieldInfo

OrgTicketId_InnerJoin_Ticket

Generated join from the foreign key OrgTicketId in this table, to its target table TicketTableInfo.

Declaration
public TargetedInnerJoin<TicketTableInfo> OrgTicketId_InnerJoin_Ticket { get; }
Property Value
Type Description
TargetedInnerJoin<TicketTableInfo>

RuntimeDefinition

Definition of the table as described in the deployed runtime dictionary

Declaration
public static SoTable RuntimeDefinition { get; }
Property Value
Type Description
SoTable

TicketId

Field 'ticket_id' in table 'ticket_log_action': Dictionary type FK, target: Ticket, .NET type: System.Int32

The id of the ticket this entry is connected to.

Declaration
public Int32FieldInfo TicketId { get; }
Property Value
Type Description
Int32FieldInfo

TicketId_InnerJoin_Ticket

Generated join from the foreign key TicketId in this table, to its target table TicketTableInfo.

Declaration
public TargetedInnerJoin<TicketTableInfo> TicketId_InnerJoin_Ticket { get; }
Property Value
Type Description
TargetedInnerJoin<TicketTableInfo>

TicketLogActionId

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

The primary key (auto-incremented)

Declaration
public Int32FieldInfo TicketLogActionId { get; }
Property Value
Type Description
Int32FieldInfo

UserId

Field 'user_id' in table 'ticket_log_action': Dictionary type FK, target: Ejuser, .NET type: System.Int32

The id of the user this entry is connected to.

Declaration
public Int32FieldInfo UserId { get; }
Property Value
Type Description
Int32FieldInfo

UserId_InnerJoin_Ejuser

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

Declaration
public TargetedInnerJoin<EjuserTableInfo> UserId_InnerJoin_Ejuser { get; }
Property Value
Type Description
TargetedInnerJoin<EjuserTableInfo>

Implements

System.ICloneable

Extension Methods

EnumUtil.MapEnums<From, To>(From)