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(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.Item[String]

TableInfo.PrimaryKeyField

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 .

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 .

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 .

AlertLevel

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

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 .

AlertStop

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

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 .

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 .

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 .

Category

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

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 .

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 .

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 .

ConnectId

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

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 .

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 .

ContactId

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

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 .

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 .

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 .

CreatedBy

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

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 .

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 .

CreatedByWorkflowId

Field 'created_by_workflow_id' in table 'ticket': Dictionary type FK, target: Workflow, .NET type: Int32

The workflow this request/ticket was created by

Declaration

public Int32FieldInfo CreatedByWorkflowId { 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 .

CreatedByWorkflowId_InnerJoin_Workflow

Generated join from the foreign key CreatedByWorkflowId in this table, to its target table WorkflowTableInfo.

Declaration

public TargetedInnerJoin<WorkflowTableInfo> CreatedByWorkflowId_InnerJoin_Workflow { get; }

Property Value

Type	Description
TargetedInnerJoin<WorkflowTableInfo>

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 .

CustId

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

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 .

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 .

DbiAgentId

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

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 .

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 .

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 .

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 .

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 .

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 .

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 .

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

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 .

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 .

FilterId

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

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 .

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 .

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 .

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 .

FormSubmissionId

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

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 .

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 .

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 .

HasAttachment

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

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 .

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 .

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 .

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 .

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 .

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 .

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 .

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 .

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 .

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 .

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 .

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 .

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 .

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 .

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 .

NumMessages

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

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 .

NumReplies

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

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 .

OrigCategory

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

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 .

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 .

OrigHumanCategoryId

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

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 .

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 .

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 .

OrigPriority

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

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 .

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 .

OwnedBy

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

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 .

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 .

Priority

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

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 .

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 .

ProjectId

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

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 .

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 .

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 .

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 .

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 .

RealTimeSpentExternally

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

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 .

RealTimeSpentInternally

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

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 .

RealTimeSpentQueue

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

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 .

RealTimeToClose

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

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 .

RealTimeToReply

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

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 .

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 .

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 .

SaleId

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

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 .

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 .

Sentiment

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

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 .

SentimentConfidence

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

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 .

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 .

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 .

SuggestedCategoryId

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

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 .

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 .

Tags

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

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 .

TicketId

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

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 .

TicketStatus

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

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 .

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 .

TicketType

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

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 .

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 .

TimeSpent

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

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 .

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 .

TimeSpentExternally

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

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 .

TimeSpentInternally

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

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 .

TimeSpentQueue

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

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 .

TimeToClose

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

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 .

TimeToReply

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

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 .

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 .

Implements

System.ICloneable

Extension Methods

EnumUtil.MapEnums<From, To>(From)

Converters.MapEnums<From, To>(From)