Class TicketRecordData

POCO (Plain Old CLR Object) class that can be used to hold data corresponding to a row from the ticket table.

Please use this class instead of a full TicketRow object when you do not need to create or update a value in the database. Row objects have a large overhead since they carry the corresponding TicketTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

POCO (Plain Old CLR Object) class that can be used to hold data corresponding to a row from the ticket table.

Please use this class instead of a full TicketRow object when you do not need to create or update a value in the database. Row objects have a large overhead since they carry the corresponding TicketTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

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

Type	Description
DateTime

Please use this class instead of a full TicketRow object when you do not need to create or update a value in the database. Row objects have a large overhead since they carry the corresponding TicketTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

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

Type	Description
Int16

Please use this class instead of a full TicketRow object when you do not need to create or update a value in the database. Row objects have a large overhead since they carry the corresponding TicketTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

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

Type	Description
Int32

Please use this class instead of a full TicketRow object when you do not need to create or update a value in the database. Row objects have a large overhead since they carry the corresponding TicketTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

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

Type	Description
DateTime

Please use this class instead of a full TicketRow object when you do not need to create or update a value in the database. Row objects have a large overhead since they carry the corresponding TicketTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

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

Type	Description
String

Please use this class instead of a full TicketRow object when you do not need to create or update a value in the database. Row objects have a large overhead since they carry the corresponding TicketTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

The id of the category a ticket is in.

Type	Description
Int32

Please use this class instead of a full TicketRow object when you do not need to create or update a value in the database. Row objects have a large overhead since they carry the corresponding TicketTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

When the ticket was closed.

Type	Description
DateTime

Please use this class instead of a full TicketRow object when you do not need to create or update a value in the database. Row objects have a large overhead since they carry the corresponding TicketTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

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

Type	Description
Int32

Please use this class instead of a full TicketRow object when you do not need to create or update a value in the database. Row objects have a large overhead since they carry the corresponding TicketTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

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

Type	Description
Int32

Please use this class instead of a full TicketRow object when you do not need to create or update a value in the database. Row objects have a large overhead since they carry the corresponding TicketTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

When the ticket was created.

Type	Description
DateTime

Please use this class instead of a full TicketRow object when you do not need to create or update a value in the database. Row objects have a large overhead since they carry the corresponding TicketTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

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

Type	Description
Int32

Please use this class instead of a full TicketRow object when you do not need to create or update a value in the database. Row objects have a large overhead since they carry the corresponding TicketTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

The workflow this request/ticket was created by

Type	Description
Int32

Please use this class instead of a full TicketRow object when you do not need to create or update a value in the database. Row objects have a large overhead since they carry the corresponding TicketTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

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

Type	Description
Int32

Please use this class instead of a full TicketRow object when you do not need to create or update a value in the database. Row objects have a large overhead since they carry the corresponding TicketTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

Integration agent (eJournal)

Type	Description
Int32

Please use this class instead of a full TicketRow object when you do not need to create or update a value in the database. Row objects have a large overhead since they carry the corresponding TicketTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

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

Type	Description
String

Please use this class instead of a full TicketRow object when you do not need to create or update a value in the database. Row objects have a large overhead since they carry the corresponding TicketTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

When the entry was last modified.

Type	Description
DateTime

Please use this class instead of a full TicketRow object when you do not need to create or update a value in the database. Row objects have a large overhead since they carry the corresponding TicketTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

Last external synchronization.

Type	Description
DateTime

Please use this class instead of a full TicketRow object when you do not need to create or update a value in the database. Row objects have a large overhead since they carry the corresponding TicketTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

Deadline for ticket.

Type	Description
DateTime

Please use this class instead of a full TicketRow object when you do not need to create or update a value in the database. Row objects have a large overhead since they carry the corresponding TicketTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

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

Type	Description
String

Please use this class instead of a full TicketRow object when you do not need to create or update a value in the database. Row objects have a large overhead since they carry the corresponding TicketTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

Address of receiving filter (mail box)

Type	Description
String

Please use this class instead of a full TicketRow object when you do not need to create or update a value in the database. Row objects have a large overhead since they carry the corresponding TicketTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

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

Type	Description
Int32

Please use this class instead of a full TicketRow object when you do not need to create or update a value in the database. Row objects have a large overhead since they carry the corresponding TicketTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

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

Type	Description
DateTime

Please use this class instead of a full TicketRow object when you do not need to create or update a value in the database. Row objects have a large overhead since they carry the corresponding TicketTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

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

Type	Description
DateTime

Please use this class instead of a full TicketRow object when you do not need to create or update a value in the database. Row objects have a large overhead since they carry the corresponding TicketTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

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

Type	Description
Int32

Please use this class instead of a full TicketRow object when you do not need to create or update a value in the database. Row objects have a large overhead since they carry the corresponding TicketTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

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

Type	Description
String

Please use this class instead of a full TicketRow object when you do not need to create or update a value in the database. Row objects have a large overhead since they carry the corresponding TicketTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

Boolean indicating if this ticket has one or more attachments.

Type	Description
Int16

Please use this class instead of a full TicketRow object when you do not need to create or update a value in the database. Row objects have a large overhead since they carry the corresponding TicketTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

The language of the first external message

Type	Description
String

Please use this class instead of a full TicketRow object when you do not need to create or update a value in the database. Row objects have a large overhead since they carry the corresponding TicketTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

The last time the ticket was modified.

Type	Description
DateTime

Please use this class instead of a full TicketRow object when you do not need to create or update a value in the database. Row objects have a large overhead since they carry the corresponding TicketTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

The total number of messages for this request.

Type	Description
Int32

Please use this class instead of a full TicketRow object when you do not need to create or update a value in the database. Row objects have a large overhead since they carry the corresponding TicketTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

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

Type	Description
Int32

Please use this class instead of a full TicketRow object when you do not need to create or update a value in the database. Row objects have a large overhead since they carry the corresponding TicketTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

The id of the category the ticket was posted to.

Type	Description
Int32

Please use this class instead of a full TicketRow object when you do not need to create or update a value in the database. Row objects have a large overhead since they carry the corresponding TicketTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

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

Type	Description
Int32

Please use this class instead of a full TicketRow object when you do not need to create or update a value in the database. Row objects have a large overhead since they carry the corresponding TicketTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

What is the origin of this ticket

Type	Description
TicketOrigin

Please use this class instead of a full TicketRow object when you do not need to create or update a value in the database. Row objects have a large overhead since they carry the corresponding TicketTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

The reference to the initial priority for the ticket.

Type	Description
Int32

Please use this class instead of a full TicketRow object when you do not need to create or update a value in the database. Row objects have a large overhead since they carry the corresponding TicketTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

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

Type	Description
Int32

Please use this class instead of a full TicketRow object when you do not need to create or update a value in the database. Row objects have a large overhead since they carry the corresponding TicketTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

The reference to the ticket_priority table.

Type	Description
Int32

Please use this class instead of a full TicketRow object when you do not need to create or update a value in the database. Row objects have a large overhead since they carry the corresponding TicketTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

Reference to project table

Type	Description
Int32

Please use this class instead of a full TicketRow object when you do not need to create or update a value in the database. Row objects have a large overhead since they carry the corresponding TicketTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

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

Type	Description
DateTime

Please use this class instead of a full TicketRow object when you do not need to create or update a value in the database. Row objects have a large overhead since they carry the corresponding TicketTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

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

Type	Description
DateTime

Please use this class instead of a full TicketRow object when you do not need to create or update a value in the database. Row objects have a large overhead since they carry the corresponding TicketTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

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

Type	Description
TicketReadStatus

Please use this class instead of a full TicketRow object when you do not need to create or update a value in the database. Row objects have a large overhead since they carry the corresponding TicketTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

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

Type	Description
Int32

Please use this class instead of a full TicketRow object when you do not need to create or update a value in the database. Row objects have a large overhead since they carry the corresponding TicketTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

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

Type	Description
Int32

Please use this class instead of a full TicketRow object when you do not need to create or update a value in the database. Row objects have a large overhead since they carry the corresponding TicketTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

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

Type	Description
Int32

Please use this class instead of a full TicketRow object when you do not need to create or update a value in the database. Row objects have a large overhead since they carry the corresponding TicketTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

Same as time_to_close, but not calculated based on priority.

Type	Description
Int32

Please use this class instead of a full TicketRow object when you do not need to create or update a value in the database. Row objects have a large overhead since they carry the corresponding TicketTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

Same as time_to_reply, but not calculated based on priority.

Type	Description
Int32

Please use this class instead of a full TicketRow object when you do not need to create or update a value in the database. Row objects have a large overhead since they carry the corresponding TicketTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

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

Type	Description
DateTime

Please use this class instead of a full TicketRow object when you do not need to create or update a value in the database. Row objects have a large overhead since they carry the corresponding TicketTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

Reference to sale table

Type	Description
Int32

Please use this class instead of a full TicketRow object when you do not need to create or update a value in the database. Row objects have a large overhead since they carry the corresponding TicketTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

The sentiment index of the last external message

Type	Description
Int32

Please use this class instead of a full TicketRow object when you do not need to create or update a value in the database. Row objects have a large overhead since they carry the corresponding TicketTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

The sentiment confidence of the last external message

Type	Description
Int32

Please use this class instead of a full TicketRow object when you do not need to create or update a value in the database. Row objects have a large overhead since they carry the corresponding TicketTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

The securitylevel of the ticket.

Type	Description
TicketSecurityLevel

Please use this class instead of a full TicketRow object when you do not need to create or update a value in the database. Row objects have a large overhead since they carry the corresponding TicketTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

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

Please use this class instead of a full TicketRow object when you do not need to create or update a value in the database. Row objects have a large overhead since they carry the corresponding TicketTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

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

Please use this class instead of a full TicketRow object when you do not need to create or update a value in the database. Row objects have a large overhead since they carry the corresponding TicketTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

Array of references to the Tags records

Please use this class instead of a full TicketRow object when you do not need to create or update a value in the database. Row objects have a large overhead since they carry the corresponding TicketTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

The primary key (auto-incremented)

Please use this class instead of a full TicketRow object when you do not need to create or update a value in the database. Row objects have a large overhead since they carry the corresponding TicketTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

User defined ticket status

Please use this class instead of a full TicketRow object when you do not need to create or update a value in the database. Row objects have a large overhead since they carry the corresponding TicketTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

Tickettype of the ticket

Please use this class instead of a full TicketRow object when you do not need to create or update a value in the database. Row objects have a large overhead since they carry the corresponding TicketTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

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

Please use this class instead of a full TicketRow object when you do not need to create or update a value in the database. Row objects have a large overhead since they carry the corresponding TicketTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

When the time_spent value was last calculated.

Please use this class instead of a full TicketRow object when you do not need to create or update a value in the database. Row objects have a large overhead since they carry the corresponding TicketTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

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

Please use this class instead of a full TicketRow object when you do not need to create or update a value in the database. Row objects have a large overhead since they carry the corresponding TicketTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

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

Please use this class instead of a full TicketRow object when you do not need to create or update a value in the database. Row objects have a large overhead since they carry the corresponding TicketTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

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

Please use this class instead of a full TicketRow object when you do not need to create or update a value in the database. Row objects have a large overhead since they carry the corresponding TicketTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

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

Please use this class instead of a full TicketRow object when you do not need to create or update a value in the database. Row objects have a large overhead since they carry the corresponding TicketTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

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

Please use this class instead of a full TicketRow object when you do not need to create or update a value in the database. Row objects have a large overhead since they carry the corresponding TicketTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

The title of the ticket.

Please use this class instead of a full TicketRow object when you do not need to create or update a value in the database. Row objects have a large overhead since they carry the corresponding TicketTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

Inheritance

Namespace: SuperOffice.CRM.Rows

Assembly: SoDataBase.dll

Syntax

Remarks

Constructors

TicketRecordData()

Declaration

Remarks

Fields

Activate

Declaration

Field Value

Remarks

AlertLevel

Declaration

Field Value

Remarks

AlertStop

Declaration

Field Value

Remarks

AlertTimeout

Declaration

Field Value

Remarks

Author

Declaration

Field Value

Remarks

Category

Declaration

Field Value

Remarks

ClosedAt

Declaration

Field Value

Remarks

ConnectId

Declaration

Field Value

Remarks

ContactId

Declaration

Field Value

Remarks

CreatedAt

Declaration

Field Value

Remarks

CreatedBy

Declaration

Field Value

Remarks

CreatedByWorkflowId

Declaration

Field Value

Remarks

CustId

Declaration

Field Value

Remarks

DbiAgentId

Declaration

Field Value

Remarks

DbiKey

Declaration

Field Value

Remarks

DbiLastModified

Declaration

Field Value

Remarks

DbiLastSyncronized

Declaration

Field Value

Remarks

Deadline