Class TicketTableInfo

Table 'ticket': This table contains the tickets (requests) of the system. Its purpose should be evident.

Inheritance

object

TableInfo

TicketTableInfo

Implements

ICloneable

Inherited Members

TableInfo.ToString()

TableInfo.RegisterFields(params FieldInfo[])

TableInfo.FieldInfoFromSoField(SoField)

TableInfo.Clone()

TableInfo.IsSameTable(TableInfo)

TableInfo.FindField(string)

TableInfo.ProtAll

TableInfo.HashCheckFields

TableInfo.TableName

TableInfo.DbName

TableInfo.IsDictionaryTable

TableInfo.All

TableInfo.this[string]

TableInfo.PrimaryKeyField

object.Equals(object)

object.Equals(object, object)

object.ReferenceEquals(object, object)

object.GetHashCode()

object.GetType()

object.MemberwiseClone()

Namespace: SuperOffice.CRM.Data

Assembly: SoDataBase.dll

Syntax

[DatabaseTable("ticket")]
public class TicketTableInfo : 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.GetTicketInfo().

Fields

DictionaryTableName

Conceptual name of table Ticket in the database dictionary: ticket

Declaration

public const string DictionaryTableName = "ticket"

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

Properties

Activate

Field 'activate' in table 'ticket': Dictionary type DateTime, .NET type: DateTime

When the ticket should be activated, if it is postponed.

Declaration

public DateTimeFieldInfo Activate { get; }

Property Value

Type	Description
DateTimeFieldInfo

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

AlertLevel

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

The alert level for the ticket. Matches the level value of the ticket_alert table.

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

AlertStop

Field 'alert_stop' in table 'ticket': Dictionary type Int, .NET type: int

If the esclatation was stopped, this fields indicates how many seconds left before the next escalation level. -1 if escalation is running.

Declaration

public Int32FieldInfo AlertStop { 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.GetTicketInfo().

AlertTimeout

Field 'alert_timeout' in table 'ticket': Dictionary type DateTime, .NET type: DateTime

The datetime for when the ticket should jump to the next alert_level.

Declaration

public DateTimeFieldInfo AlertTimeout { get; }

Property Value

Type	Description
DateTimeFieldInfo

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

Author

Field 'author' in table 'ticket': Dictionary type String[256], .NET type: string

A string representing the author of the ticket (same as author of first message).

Declaration

public StringFieldInfo Author { 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.GetTicketInfo().

Category

Field 'category' in table 'ticket': Dictionary type FK, target: EjCategory, .NET type: int

The id of the category a ticket is in.

Declaration

public Int32FieldInfo Category { 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.GetTicketInfo().

Category_InnerJoin_EjCategory

Generated join from the foreign key Category in this table, to its target table EjCategoryTableInfo.

Declaration

public TargetedInnerJoin<EjCategoryTableInfo> Category_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.GetTicketInfo().

ClosedAt

Field 'closed_at' in table 'ticket': Dictionary type DateTime, .NET type: DateTime

When the ticket was closed.

Declaration

public DateTimeFieldInfo ClosedAt { get; }

Property Value

Type	Description
DateTimeFieldInfo

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

ConnectId

Field 'connect_id' in table 'ticket': Dictionary type FK, target: Ticket, .NET type: int

If a ticket is connected to another ticket, this field is set to the id of the 'master' ticket.

Declaration

public Int32FieldInfo ConnectId { 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.GetTicketInfo().

ConnectId_InnerJoin_Ticket

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

Declaration

public TargetedInnerJoin<TicketTableInfo> ConnectId_InnerJoin_Ticket { get; }

Property Value

Type	Description
TargetedInnerJoin<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.GetTicketInfo().

ContactId

Field 'contact_id' in table 'ticket': Dictionary type FK, target: Contact, .NET type: int

The company of the person in the cust_id field, if that person belongs to a company

Declaration

public Int32FieldInfo ContactId { 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.GetTicketInfo().

ContactId_InnerJoin_Contact

Generated join from the foreign key ContactId in this table, to its target table ContactTableInfo.

Declaration

public TargetedInnerJoin<ContactTableInfo> ContactId_InnerJoin_Contact { get; }

Property Value

Type	Description
TargetedInnerJoin<ContactTableInfo>

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

CreatedAt

Field 'created_at' in table 'ticket': Dictionary type DateTime, .NET type: DateTime

When the ticket was created.

Declaration

public DateTimeFieldInfo CreatedAt { get; }

Property Value

Type	Description
DateTimeFieldInfo

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

CreatedBy

Field 'created_by' in table 'ticket': Dictionary type FK, target: Ejuser, .NET type: int

The id of the user who created the ticket. 1 (system user) if the ticket was created externally

Declaration

public Int32FieldInfo CreatedBy { 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.GetTicketInfo().

CreatedBy_InnerJoin_Ejuser

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

Declaration

public TargetedInnerJoin<EjuserTableInfo> CreatedBy_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.GetTicketInfo().

CustId

Field 'cust_id' in table 'ticket': Dictionary type FK, target: Person, .NET type: int

The reference to the customer. NULL or -1 if ticket is not connected to customer.

Declaration

public Int32FieldInfo CustId { 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.GetTicketInfo().

CustId_InnerJoin_Person

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

Declaration

public TargetedInnerJoin<PersonTableInfo> CustId_InnerJoin_Person { get; }

Property Value

Type	Description
TargetedInnerJoin<PersonTableInfo>

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

DbiAgentId

Field 'dbi_agent_id' in table 'ticket': Dictionary type FK, target: DbiAgent, .NET type: int

Integration agent (eJournal)

Declaration

public Int32FieldInfo DbiAgentId { 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.GetTicketInfo().

DbiAgentId_InnerJoin_DbiAgent

Generated join from the foreign key DbiAgentId in this table, to its target table DbiAgentTableInfo.

Declaration

public TargetedInnerJoin<DbiAgentTableInfo> DbiAgentId_InnerJoin_DbiAgent { get; }

Property Value

Type	Description
TargetedInnerJoin<DbiAgentTableInfo>

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

DbiKey

Field 'dbi_key' in table 'ticket': Dictionary type String[256], .NET type: string

The primary key for the integrated entry in the external datasource.

Declaration

public StringFieldInfo DbiKey { 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.GetTicketInfo().

DbiLastModified

Field 'dbi_last_modified' in table 'ticket': Dictionary type DateTime, .NET type: DateTime

When the entry was last modified.

Declaration

public DateTimeFieldInfo DbiLastModified { get; }

Property Value

Type	Description
DateTimeFieldInfo

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

DbiLastSyncronized

Field 'dbi_last_syncronized' in table 'ticket': Dictionary type DateTime, .NET type: DateTime

Last external synchronization.

Declaration

public DateTimeFieldInfo DbiLastSyncronized { get; }

Property Value

Type	Description
DateTimeFieldInfo

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

Deadline

Field 'deadline' in table 'ticket': Dictionary type DateTime, .NET type: DateTime

Deadline for ticket.

Declaration

public DateTimeFieldInfo Deadline { get; }

Property Value

Type	Description
DateTimeFieldInfo

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

Definition

Definition of the table as described in the deployed runtime dictionary

Declaration

public override SoTable Definition { get; }

Property Value

Type	Description
SoTable

Overrides

TableInfo.Definition

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

DictionaryTableNumber

Table number for table Ticket 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.GetTicketInfo().

DisplayFilter

Field 'display_filter' in table 'ticket': Dictionary type String[256], .NET type: string

The name of the mailbox from which the ticket was created. Only for displaypurposes

Declaration

public StringFieldInfo DisplayFilter { 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.GetTicketInfo().

FilterAddress

Field 'filter_address' in table 'ticket': Dictionary type String[256], .NET type: string

Address of receiving filter (mail box)

Declaration

public StringFieldInfo FilterAddress { 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.GetTicketInfo().

FilterId

Field 'filter_id' in table 'ticket': Dictionary type FK, target: MailInFilter, .NET type: int

The reference to the mailbox from which the ticket was created. NULL or -1 if the ticket was not created by a mailbox.

Declaration

public Int32FieldInfo FilterId { 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.GetTicketInfo().

FilterId_InnerJoin_MailInFilter

Generated join from the foreign key FilterId in this table, to its target table MailInFilterTableInfo.

Declaration

public TargetedInnerJoin<MailInFilterTableInfo> FilterId_InnerJoin_MailInFilter { get; }

Property Value

Type	Description
TargetedInnerJoin<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.GetTicketInfo().

FirstReadByOwner

Field 'first_read_by_owner' in table 'ticket': Dictionary type DateTime, .NET type: DateTime

The datetime for when the ticket first was read by the current owner.

Declaration

public DateTimeFieldInfo FirstReadByOwner { get; }

Property Value

Type	Description
DateTimeFieldInfo

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

FirstReadByUser

Field 'first_read_by_user' in table 'ticket': Dictionary type DateTime, .NET type: DateTime

The datetime for when the ticket first was read by a user.

Declaration

public DateTimeFieldInfo FirstReadByUser { get; }

Property Value

Type	Description
DateTimeFieldInfo

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

FormSubmissionId

Field 'form_submission_id' in table 'ticket': Dictionary type FK, target: FormSubmission, .NET type: int

If this ticket was created from a form submission, this field will point to that record

Declaration

public Int32FieldInfo FormSubmissionId { 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.GetTicketInfo().

FormSubmissionId_InnerJoin_FormSubmission

Generated join from the foreign key FormSubmissionId in this table, to its target table FormSubmissionTableInfo.

Declaration

public TargetedInnerJoin<FormSubmissionTableInfo> FormSubmissionId_InnerJoin_FormSubmission { get; }

Property Value

Type	Description
TargetedInnerJoin<FormSubmissionTableInfo>

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

FromAddress

Field 'from_address' in table 'ticket': Dictionary type String[4001], .NET type: string

The from-address used when this ticket got created, e.g. by email

Declaration

public StringFieldInfo FromAddress { 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.GetTicketInfo().

HasAttachment

Field 'has_attachment' in table 'ticket': Dictionary type Bool, .NET type: short

Boolean indicating if this ticket has one or more attachments.

Declaration

public UInt16FieldInfo HasAttachment { get; }

Property Value

Type	Description
UInt16FieldInfo

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

Language

Field 'language' in table 'ticket': Dictionary type String[11], .NET type: string

The language of the first external message

Declaration

public StringFieldInfo Language { 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.GetTicketInfo().

LastChanged

Field 'last_changed' in table 'ticket': Dictionary type DateTime, .NET type: DateTime

The last time the ticket was modified.

Declaration

public DateTimeFieldInfo LastChanged { get; }

Property Value

Type	Description
DateTimeFieldInfo

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

LeftOuterJoin_ChatSession_TicketId

Generated left outer join from the primary key TicketId on this table, to ChatSession.TicketId.

Declaration

public TargetedLeftOuterJoin<ChatSessionTableInfo> LeftOuterJoin_ChatSession_TicketId { get; }

Property Value

Type	Description
TargetedLeftOuterJoin<ChatSessionTableInfo>

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

LeftOuterJoin_EjMessage_TicketId

Generated left outer join from the primary key TicketId on this table, to EjMessage.TicketId.

Declaration

public TargetedLeftOuterJoin<EjMessageTableInfo> LeftOuterJoin_EjMessage_TicketId { get; }

Property Value

Type	Description
TargetedLeftOuterJoin<EjMessageTableInfo>

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

LeftOuterJoin_Hotlist_TicketId

Generated left outer join from the primary key TicketId on this table, to Hotlist.TicketId.

Declaration

public TargetedLeftOuterJoin<HotlistTableInfo> LeftOuterJoin_Hotlist_TicketId { get; }

Property Value

Type	Description
TargetedLeftOuterJoin<HotlistTableInfo>

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

LeftOuterJoin_Notify_TicketId

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

Declaration

public TargetedLeftOuterJoin<NotifyTableInfo> LeftOuterJoin_Notify_TicketId { 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.GetTicketInfo().

LeftOuterJoin_Outbox_TicketId

Generated left outer join from the primary key TicketId on this table, to Outbox.TicketId.

Declaration

public TargetedLeftOuterJoin<OutboxTableInfo> LeftOuterJoin_Outbox_TicketId { get; }

Property Value

Type	Description
TargetedLeftOuterJoin<OutboxTableInfo>

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

LeftOuterJoin_SShipmentAddr_TicketId

Generated left outer join from the primary key TicketId on this table, to SShipmentAddr.TicketId.

Declaration

public TargetedLeftOuterJoin<SShipmentAddrTableInfo> LeftOuterJoin_SShipmentAddr_TicketId { get; }

Property Value

Type	Description
TargetedLeftOuterJoin<SShipmentAddrTableInfo>

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

LeftOuterJoin_TicketCustomers_TicketId

Generated left outer join from the primary key TicketId on this table, to TicketCustomers.TicketId.

Declaration

public TargetedLeftOuterJoin<TicketCustomersTableInfo> LeftOuterJoin_TicketCustomers_TicketId { get; }

Property Value

Type	Description
TargetedLeftOuterJoin<TicketCustomersTableInfo>

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

LeftOuterJoin_TicketLogAction_OrgTicketId

Generated left outer join from the primary key TicketId on this table, to TicketLogAction.OrgTicketId.

Declaration

public TargetedLeftOuterJoin<TicketLogActionTableInfo> LeftOuterJoin_TicketLogAction_OrgTicketId { get; }

Property Value

Type	Description
TargetedLeftOuterJoin<TicketLogActionTableInfo>

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

LeftOuterJoin_TicketLogAction_TicketId

Generated left outer join from the primary key TicketId on this table, to TicketLogAction.TicketId.

Declaration

public TargetedLeftOuterJoin<TicketLogActionTableInfo> LeftOuterJoin_TicketLogAction_TicketId { get; }

Property Value

Type	Description
TargetedLeftOuterJoin<TicketLogActionTableInfo>

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

LeftOuterJoin_TicketLogChange_TicketId

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

Declaration

public TargetedLeftOuterJoin<TicketLogChangeTableInfo> LeftOuterJoin_TicketLogChange_TicketId { get; }

Property Value

Type	Description
TargetedLeftOuterJoin<TicketLogChangeTableInfo>

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

LeftOuterJoin_TicketLog_TicketId

Generated left outer join from the primary key TicketId on this table, to TicketLog.TicketId.

Declaration

public TargetedLeftOuterJoin<TicketLogTableInfo> LeftOuterJoin_TicketLog_TicketId { get; }

Property Value

Type	Description
TargetedLeftOuterJoin<TicketLogTableInfo>

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

LeftOuterJoin_TicketStatusHistory_TicketId

Generated left outer join from the primary key TicketId on this table, to TicketStatusHistory.TicketId.

Declaration

public TargetedLeftOuterJoin<TicketStatusHistoryTableInfo> LeftOuterJoin_TicketStatusHistory_TicketId { get; }

Property Value

Type	Description
TargetedLeftOuterJoin<TicketStatusHistoryTableInfo>

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

NumMessages

Field 'num_messages' in table 'ticket': Dictionary type Int, .NET type: int

The total number of messages for this request.

Declaration

public Int32FieldInfo NumMessages { 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.GetTicketInfo().

NumReplies

Field 'num_replies' in table 'ticket': Dictionary type Int, .NET type: int

The number of replies (messages) to the customer for this request.

Declaration

public Int32FieldInfo NumReplies { 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.GetTicketInfo().

OrigCategory

Field 'orig_category' in table 'ticket': Dictionary type FK, target: EjCategory, .NET type: int

The id of the category the ticket was posted to.

Declaration

public Int32FieldInfo OrigCategory { 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.GetTicketInfo().

OrigCategory_InnerJoin_EjCategory

Generated join from the foreign key OrigCategory in this table, to its target table EjCategoryTableInfo.

Declaration

public TargetedInnerJoin<EjCategoryTableInfo> OrigCategory_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.GetTicketInfo().

OrigHumanCategoryId

Field 'origHumanCategory_id' in table 'ticket': Dictionary type FK, target: EjCategory, .NET type: int

Will contain the category id selected by the user, when having the choice of using the suggested category or manually selecting a category

Declaration

public Int32FieldInfo OrigHumanCategoryId { 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.GetTicketInfo().

OrigHumanCategoryId_InnerJoin_EjCategory

Generated join from the foreign key OrigHumanCategoryId in this table, to its target table EjCategoryTableInfo.

Declaration

public TargetedInnerJoin<EjCategoryTableInfo> OrigHumanCategoryId_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.GetTicketInfo().

OrigPriority

Field 'orig_priority' in table 'ticket': Dictionary type FK, target: TicketPriority, .NET type: int

The reference to the initial priority for the ticket.

Declaration

public Int32FieldInfo OrigPriority { 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.GetTicketInfo().

OrigPriority_InnerJoin_TicketPriority

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

Declaration

public TargetedInnerJoin<TicketPriorityTableInfo> OrigPriority_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.GetTicketInfo().

Origin

Field 'origin' in table 'ticket': Dictionary type Enum, .NET type: TicketOrigin

What is the origin of this ticket

Declaration

public TicketOriginFieldInfo Origin { get; }

Property Value

Type	Description
TicketOriginFieldInfo

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

OwnedBy

Field 'owned_by' in table 'ticket': Dictionary type FK, target: Ejuser, .NET type: int

The id of the user who owns the ticket. 1 (system user) if the ticket is unassigned.

Declaration

public Int32FieldInfo OwnedBy { 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.GetTicketInfo().

OwnedBy_InnerJoin_Ejuser

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

Declaration

public TargetedInnerJoin<EjuserTableInfo> OwnedBy_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.GetTicketInfo().

Priority

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

The reference to the ticket_priority table.

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

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

ProjectId

Field 'project_id' in table 'ticket': Dictionary type FK, target: Project, .NET type: int

Reference to project table

Declaration

public Int32FieldInfo ProjectId { 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.GetTicketInfo().

ProjectId_InnerJoin_Project

Generated join from the foreign key ProjectId in this table, to its target table ProjectTableInfo.

Declaration

public TargetedInnerJoin<ProjectTableInfo> ProjectId_InnerJoin_Project { get; }

Property Value

Type	Description
TargetedInnerJoin<ProjectTableInfo>

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

ReadByCustomer

Field 'read_by_customer' in table 'ticket': Dictionary type DateTime, .NET type: DateTime

The datetime for when the ticket was read by the customer.

Declaration

public DateTimeFieldInfo ReadByCustomer { get; }

Property Value

Type	Description
DateTimeFieldInfo

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

ReadByOwner

Field 'read_by_owner' in table 'ticket': Dictionary type DateTime, .NET type: DateTime

The datetime for when the ticket last was read by the owner.

Declaration

public DateTimeFieldInfo ReadByOwner { get; }

Property Value

Type	Description
DateTimeFieldInfo

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

ReadStatus

Field 'read_status' in table 'ticket': Dictionary type Enum, .NET type: TicketReadStatus

Whether the owner has read the ticket or not (red, yellow, green).

Declaration

public TicketReadStatusFieldInfo ReadStatus { get; }

Property Value

Type	Description
TicketReadStatusFieldInfo

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

RealTimeSpentExternally

Field 'real_time_spent_externally' in table 'ticket': Dictionary type Int, .NET type: int

The total time (seconds) within 24x7 the ticket has been in a external waiting status (configurable), not including current state

Declaration

public Int32FieldInfo RealTimeSpentExternally { 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.GetTicketInfo().

RealTimeSpentInternally

Field 'real_time_spent_internally' in table 'ticket': Dictionary type Int, .NET type: int

The total time (seconds) within 24x7 the ticket has been in an open status (configurable), not including current state

Declaration

public Int32FieldInfo RealTimeSpentInternally { 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.GetTicketInfo().

RealTimeSpentQueue

Field 'real_time_spent_queue' in table 'ticket': Dictionary type Int, .NET type: int

The total time (seconds) within 24x7 hours the ticket has been in a queue status, not including current state

Declaration

public Int32FieldInfo RealTimeSpentQueue { 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.GetTicketInfo().

RealTimeToClose

Field 'real_time_to_close' in table 'ticket': Dictionary type Int, .NET type: int

Same as time_to_close, but not calculated based on priority.

Declaration

public Int32FieldInfo RealTimeToClose { 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.GetTicketInfo().

RealTimeToReply

Field 'real_time_to_reply' in table 'ticket': Dictionary type Int, .NET type: int

Same as time_to_reply, but not calculated based on priority.

Declaration

public Int32FieldInfo RealTimeToReply { 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.GetTicketInfo().

RepliedAt

Field 'replied_at' in table 'ticket': Dictionary type DateTime, .NET type: DateTime

The datetime for when the ticket was replied to. I.e. the first external message added to the ticket.

Declaration

public DateTimeFieldInfo RepliedAt { get; }

Property Value

Type	Description
DateTimeFieldInfo

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

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

SaleId

Field 'sale_id' in table 'ticket': Dictionary type FK, target: Sale, .NET type: int

Reference to sale table

Declaration

public Int32FieldInfo SaleId { 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.GetTicketInfo().

SaleId_InnerJoin_Sale

Generated join from the foreign key SaleId in this table, to its target table SaleTableInfo.

Declaration

public TargetedInnerJoin<SaleTableInfo> SaleId_InnerJoin_Sale { get; }

Property Value

Type	Description
TargetedInnerJoin<SaleTableInfo>

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

Sentiment

Field 'sentiment' in table 'ticket': Dictionary type Int, .NET type: int

The sentiment index of the last external message

Declaration

public Int32FieldInfo Sentiment { 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.GetTicketInfo().

SentimentConfidence

Field 'sentimentConfidence' in table 'ticket': Dictionary type Int, .NET type: int

The sentiment confidence of the last external message

Declaration

public Int32FieldInfo SentimentConfidence { 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.GetTicketInfo().

Slevel

Field 'slevel' in table 'ticket': Dictionary type Enum, .NET type: TicketSecurityLevel

The securitylevel of the ticket.

Declaration

public TicketSecurityLevelFieldInfo Slevel { get; }

Property Value

Type	Description
TicketSecurityLevelFieldInfo

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

Status

Field 'status' in table 'ticket': Dictionary type Enum, .NET type: TicketBaseStatus

The status of the ticket. I.e. active/closed/postponed/deleted

Declaration

public TicketBaseStatusFieldInfo Status { get; }

Property Value

Type	Description
TicketBaseStatusFieldInfo

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

SuggestedCategoryId

Field 'suggestedCategory_id' in table 'ticket': Dictionary type FK, target: EjCategory, .NET type: int

Suggestion for categorization, based on the text of the message (AI)

Declaration

public Int32FieldInfo SuggestedCategoryId { 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.GetTicketInfo().

SuggestedCategoryId_InnerJoin_EjCategory

Generated join from the foreign key SuggestedCategoryId in this table, to its target table EjCategoryTableInfo.

Declaration

public TargetedInnerJoin<EjCategoryTableInfo> SuggestedCategoryId_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.GetTicketInfo().

Tags

Field 'tags' in table 'ticket': Dictionary type FKArray, .NET type: int

Array of references to the Tags records

Declaration

public Int32ArrayFieldInfo Tags { get; }

Property Value

Type	Description
Int32ArrayFieldInfo

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

TicketId

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

The primary key (auto-incremented)

Declaration

public Int32FieldInfo TicketId { 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.GetTicketInfo().

TicketStatus

Field 'ticket_status' in table 'ticket': Dictionary type FK, target: TicketStatus, .NET type: int

User defined ticket status

Declaration

public Int32FieldInfo TicketStatus { 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.GetTicketInfo().

TicketStatus_InnerJoin_TicketStatus

Generated join from the foreign key TicketStatus in this table, to its target table TicketStatusTableInfo.

Declaration

public TargetedInnerJoin<TicketStatusTableInfo> TicketStatus_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.GetTicketInfo().

TicketType

Field 'ticket_type' in table 'ticket': Dictionary type FK, target: TicketType, .NET type: int

Tickettype of the ticket

Declaration

public Int32FieldInfo TicketType { 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.GetTicketInfo().

TicketType_InnerJoin_TicketType

Generated join from the foreign key TicketType in this table, to its target table TicketTypeTableInfo.

Declaration

public TargetedInnerJoin<TicketTypeTableInfo> TicketType_InnerJoin_TicketType { get; }

Property Value

Type	Description
TargetedInnerJoin<TicketTypeTableInfo>

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

TimeSpent

Field 'time_spent' in table 'ticket': Dictionary type Int, .NET type: int

The total time (minutes). Aggregated time spent from ticket's messages. Read-only for external use.

Declaration

public Int32FieldInfo TimeSpent { 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.GetTicketInfo().

TimeSpentCalculated

Field 'time_spent_calculated' in table 'ticket': Dictionary type DateTime, .NET type: DateTime

When the time_spent value was last calculated.

Declaration

public DateTimeFieldInfo TimeSpentCalculated { get; }

Property Value

Type	Description
DateTimeFieldInfo

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

TimeSpentExternally

Field 'time_spent_externally' in table 'ticket': Dictionary type Int, .NET type: int

The total time (seconds) within the priority's office hours the ticket has been in a external waiting status (configurable), not including current state

Declaration

public Int32FieldInfo TimeSpentExternally { 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.GetTicketInfo().

TimeSpentInternally

Field 'time_spent_internally' in table 'ticket': Dictionary type Int, .NET type: int

The total time (seconds) within the priority's office hours the ticket has been in an open status (configurable), not including current state

Declaration

public Int32FieldInfo TimeSpentInternally { 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.GetTicketInfo().

TimeSpentQueue

Field 'time_spent_queue' in table 'ticket': Dictionary type Int, .NET type: int

The total time (seconds) within the priority's office hours the ticket has been in a queue status, not including current state

Declaration

public Int32FieldInfo TimeSpentQueue { 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.GetTicketInfo().

TimeToClose

Field 'time_to_close' in table 'ticket': Dictionary type Int, .NET type: int

The time (minutes) between when the ticket was created and when it was closed. Calculated based on priority's timeframe.

Declaration

public Int32FieldInfo TimeToClose { 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.GetTicketInfo().

TimeToReply

Field 'time_to_reply' in table 'ticket': Dictionary type Int, .NET type: int

The time (minutes) between when the ticket was created and when it was replied to. Calculated based on priority's timeframe.

Declaration

public Int32FieldInfo TimeToReply { 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.GetTicketInfo().

Title

Field 'title' in table 'ticket': Dictionary type String[256], .NET type: string

The title of the ticket.

Declaration

public StringFieldInfo Title { 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.GetTicketInfo().

Implements

ICloneable

Extension Methods

EnumUtil.MapEnums<From, To>(From)

Converters.MapEnums<From, To>(From)