Class DBC.TicketStatusHistoryFields

Fields for TicketStatusHistory, This table contains the history of a tickets statuses. Each time a ticket changes status a copy of the previous status of the record will be saved

Inheritance

System.Object

DBC.TicketStatusHistoryFields

Namespace: SuperOffice.CRM.Data

Assembly: SoDataBase.dll

Syntax

public static class TicketStatusHistoryFields : Object

Fields

FromDatetime

TicketStatusHistory.FromDatetime:

Declaration

public const string FromDatetime = "from_datetime"

Field Value

Type	Description
System.String

RealTimespan

TicketStatusHistory.RealTimespan: The time (seconds) the ticket was in that status. Not calculated based on priority's timeframe.

Declaration

public const string RealTimespan = "real_timespan"

Field Value

Type	Description
System.String

TicketId

TicketStatusHistory.TicketId: Reference to a ticket

Declaration

public const string TicketId = "ticket_id"

Field Value

Type	Description
System.String

TicketStatus

TicketStatusHistory.TicketStatus: User defined ticket status

Declaration

public const string TicketStatus = "ticket_status"

Field Value

Type	Description
System.String

TicketStatusHistoryId

TicketStatusHistory.TicketStatusHistoryId: The primary key (auto-incremented)

Declaration

public const string TicketStatusHistoryId = "id"

Field Value

Type	Description
System.String

Timespan

TicketStatusHistory.Timespan: The time (seconds) the ticket was in that status. Calculated based on priority's timeframe.

Declaration

public const string Timespan = "timespan"

Field Value

Type	Description
System.String

ToDatetime

TicketStatusHistory.ToDatetime:

Declaration

public const string ToDatetime = "to_datetime"

Field Value

Type	Description
System.String