Class TicketTableInfo

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

Inheritance

System.Object

TableInfo

TicketTableInfo

Implements

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

Properties

Activate

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

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

Declaration

public DateTimeFieldInfo Activate { get; }

Property Value

Type	Description
DateTimeFieldInfo

AlertLevel

Field 'alert_level' in table 'ticket': Dictionary type Short, .NET type: System.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

AlertStop

Field 'alert_stop' in table 'ticket': Dictionary type Int, .NET type: System.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

AlertTimeout

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

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

Declaration

public DateTimeFieldInfo AlertTimeout { get; }

Property Value

Type	Description
DateTimeFieldInfo

Author

Field 'author' in table 'ticket': Dictionary type String[256], .NET type: System.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

Category

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

The id of the category a ticket is in.

Declaration

public Int32FieldInfo Category { get; }

Property Value

Type	Description
Int32FieldInfo

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>

ClosedAt

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

When the ticket was closed.

Declaration

public DateTimeFieldInfo ClosedAt { get; }

Property Value

Type	Description
DateTimeFieldInfo

ConnectId

Field 'connect_id' in table 'ticket': Dictionary type FK, target: Ticket, .NET type: System.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

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>

ContactId

Field 'contact_id' in table 'ticket': Dictionary type FK, target: Contact, .NET type: System.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

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>

CreatedAt

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

When the ticket was created.

Declaration

public DateTimeFieldInfo CreatedAt { get; }

Property Value

Type	Description
DateTimeFieldInfo

CreatedBy

Field 'created_by' in table 'ticket': Dictionary type FK, target: Ejuser, .NET type: System.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

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>

CustId

Field 'cust_id' in table 'ticket': Dictionary type FK, target: Person, .NET type: System.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

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>

DbiAgentId

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

Integration agent (eJournal)

Declaration

public Int32FieldInfo DbiAgentId { get; }

Property Value

Type	Description
Int32FieldInfo

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>

DbiKey

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

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

Declaration

public StringFieldInfo DbiKey { get; }

Property Value

Type	Description
StringFieldInfo

DbiLastModified

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

When the entry was last modified.

Declaration

public DateTimeFieldInfo DbiLastModified { get; }

Property Value

Type	Description
DateTimeFieldInfo

DbiLastSyncronized

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

Last external synchronization.

Declaration

public DateTimeFieldInfo DbiLastSyncronized { get; }

Property Value

Type	Description
DateTimeFieldInfo

Deadline

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

Deadline for ticket.

Declaration

public DateTimeFieldInfo Deadline { get; }

Property Value

Type	Description
DateTimeFieldInfo

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

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

DisplayFilter

Field 'display_filter' in table 'ticket': Dictionary type String[256], .NET type: System.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

FilterAddress

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

Address of receiving filter (mail box)

Declaration

public StringFieldInfo FilterAddress { get; }

Property Value

Type	Description
StringFieldInfo

FilterId

Field 'filter_id' in table 'ticket': Dictionary type FK, target: MailInFilter, .NET type: System.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

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>

FirstReadByOwner

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

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

Declaration

public DateTimeFieldInfo FirstReadByOwner { get; }

Property Value

Type	Description
DateTimeFieldInfo

FirstReadByUser

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

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

Declaration

public DateTimeFieldInfo FirstReadByUser { get; }

Property Value

Type	Description
DateTimeFieldInfo

FormSubmissionId

Field 'form_submission_id' in table 'ticket': Dictionary type FK, target: FormSubmission, .NET type: System.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

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>

FromAddress

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

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

Declaration

public StringFieldInfo FromAddress { get; }

Property Value

Type	Description
StringFieldInfo

HasAttachment

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

Boolean indicating if this ticket has one or more attachments.

Declaration

public UInt16FieldInfo HasAttachment { get; }

Property Value

Type	Description
UInt16FieldInfo

Language

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

The language of the first external message

Declaration

public StringFieldInfo Language { get; }

Property Value

Type	Description
StringFieldInfo

LastChanged

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

The last time the ticket was modified.

Declaration

public DateTimeFieldInfo LastChanged { get; }

Property Value

Type	Description
DateTimeFieldInfo

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>

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>

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>

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>

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>

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>

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>

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>

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>

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>

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>

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>

NumMessages

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

The total number of messages for this request.

Declaration

public Int32FieldInfo NumMessages { get; }

Property Value

Type	Description
Int32FieldInfo

NumReplies

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

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

Declaration

public Int32FieldInfo NumReplies { get; }

Property Value

Type	Description
Int32FieldInfo

OrigCategory

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

The id of the category the ticket was posted to.

Declaration

public Int32FieldInfo OrigCategory { get; }

Property Value

Type	Description
Int32FieldInfo

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>

OrigHumanCategoryId

Field 'origHumanCategory_id' in table 'ticket': Dictionary type FK, target: EjCategory, .NET type: System.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

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>

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

OrigPriority

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

The reference to the initial priority for the ticket.

Declaration

public Int32FieldInfo OrigPriority { get; }

Property Value

Type	Description
Int32FieldInfo

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>

OwnedBy

Field 'owned_by' in table 'ticket': Dictionary type FK, target: Ejuser, .NET type: System.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

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>

Priority

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

The reference to the ticket_priority table.

Declaration

public Int32FieldInfo Priority { get; }

Property Value

Type	Description
Int32FieldInfo

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>

ProjectId

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

Reference to project table

Declaration

public Int32FieldInfo ProjectId { get; }

Property Value

Type	Description
Int32FieldInfo

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>

ReadByCustomer

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

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

Declaration

public DateTimeFieldInfo ReadByCustomer { get; }

Property Value

Type	Description
DateTimeFieldInfo

ReadByOwner

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

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

Declaration

public DateTimeFieldInfo ReadByOwner { get; }

Property Value

Type	Description
DateTimeFieldInfo

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

RealTimeSpentExternally

Field 'real_time_spent_externally' in table 'ticket': Dictionary type Int, .NET type: System.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

RealTimeSpentInternally

Field 'real_time_spent_internally' in table 'ticket': Dictionary type Int, .NET type: System.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

RealTimeSpentQueue

Field 'real_time_spent_queue' in table 'ticket': Dictionary type Int, .NET type: System.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

RealTimeToClose

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

Same as time_to_close, but not calculated based on priority.

Declaration

public Int32FieldInfo RealTimeToClose { get; }

Property Value

Type	Description
Int32FieldInfo

RealTimeToReply

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

Same as time_to_reply, but not calculated based on priority.

Declaration

public Int32FieldInfo RealTimeToReply { get; }

Property Value

Type	Description
Int32FieldInfo

RepliedAt

Field 'replied_at' in table 'ticket': Dictionary type DateTime, .NET type: System.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

RuntimeDefinition

Definition of the table as described in the deployed runtime dictionary

Declaration

public static SoTable RuntimeDefinition { get; }

Property Value

Type	Description
SoTable

SaleId

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

Reference to sale table

Declaration

public Int32FieldInfo SaleId { get; }

Property Value

Type	Description
Int32FieldInfo

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>

Sentiment

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

The sentiment index of the last external message

Declaration

public Int32FieldInfo Sentiment { get; }

Property Value

Type	Description
Int32FieldInfo

SentimentConfidence

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

The sentiment confidence of the last external message

Declaration

public Int32FieldInfo SentimentConfidence { get; }

Property Value

Type	Description
Int32FieldInfo

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

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

SuggestedCategoryId

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

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

Declaration

public Int32FieldInfo SuggestedCategoryId { get; }

Property Value

Type	Description
Int32FieldInfo

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>

Tags

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

Array of references to the Tags records

Declaration

public Int32ArrayFieldInfo Tags { get; }

Property Value

Type	Description
Int32ArrayFieldInfo

TicketId

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

The primary key (auto-incremented)

Declaration

public Int32FieldInfo TicketId { get; }

Property Value

Type	Description
Int32FieldInfo

TicketStatus

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

User defined ticket status

Declaration

public Int32FieldInfo TicketStatus { get; }

Property Value

Type	Description
Int32FieldInfo

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>

TicketType

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

Tickettype of the ticket

Declaration

public Int32FieldInfo TicketType { get; }

Property Value

Type	Description
Int32FieldInfo

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>

TimeSpent

Field 'time_spent' in table 'ticket': Dictionary type Int, .NET type: System.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

TimeSpentCalculated

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

When the time_spent value was last calculated.

Declaration

public DateTimeFieldInfo TimeSpentCalculated { get; }

Property Value

Type	Description
DateTimeFieldInfo

TimeSpentExternally

Field 'time_spent_externally' in table 'ticket': Dictionary type Int, .NET type: System.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

TimeSpentInternally

Field 'time_spent_internally' in table 'ticket': Dictionary type Int, .NET type: System.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

TimeSpentQueue

Field 'time_spent_queue' in table 'ticket': Dictionary type Int, .NET type: System.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

TimeToClose

Field 'time_to_close' in table 'ticket': Dictionary type Int, .NET type: System.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

TimeToReply

Field 'time_to_reply' in table 'ticket': Dictionary type Int, .NET type: System.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

Title

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

The title of the ticket.

Declaration

public StringFieldInfo Title { get; }

Property Value

Type	Description
StringFieldInfo

Implements

System.ICloneable

Extension Methods

EnumUtil.MapEnums<From, To>(From)

Converters.MapEnums<From, To>(From)