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
Inherited Members
Namespace: SuperOffice.CRM.Data
Assembly: SoDataBase.dll
Syntax
public static class DBC.TicketStatusHistoryFields
Fields
FromDatetime
TicketStatusHistory.FromDatetime:
Declaration
public const string FromDatetime = "from_datetime"
Field Value
Type | Description |
---|---|
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 |
---|---|
string |
TicketId
TicketStatusHistory.TicketId: Reference to a ticket
Declaration
public const string TicketId = "ticket_id"
Field Value
Type | Description |
---|---|
string |
TicketStatus
TicketStatusHistory.TicketStatus: User defined ticket status
Declaration
public const string TicketStatus = "ticket_status"
Field Value
Type | Description |
---|---|
string |
TicketStatusHistoryId
TicketStatusHistory.TicketStatusHistoryId: The primary key (auto-incremented)
Declaration
public const string TicketStatusHistoryId = "id"
Field Value
Type | Description |
---|---|
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 |
---|---|
string |
ToDatetime
TicketStatusHistory.ToDatetime:
Declaration
public const string ToDatetime = "to_datetime"
Field Value
Type | Description |
---|---|
string |