Class TicketStatusTableInfo
Table 'ticket_status': This table user defined ticket status values.
Implements
Inherited Members
Namespace: SuperOffice.CRM.Data
Assembly: SoDataBase.dll
Syntax
[DatabaseTable("ticket_status")]
public class TicketStatusTableInfo : 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 TicketStatus in the database dictionary: ticket_status
Declaration
public const string DictionaryTableName = "ticket_status"
Field Value
Type | Description |
---|---|
String |
Properties
Definition
Definition of the table as described in the deployed runtime dictionary
Declaration
public override SoTable Definition { get; }
Property Value
Type | Description |
---|---|
SoTable |
Overrides
Deleted
Field 'deleted' in table 'ticket_status': Dictionary type Bool, .NET type: Int16
Whether the status is deleted (unavailable) or not
Declaration
public UInt16FieldInfo Deleted { get; }
Property Value
Type | Description |
---|---|
UInt16FieldInfo |
DictionaryTableNumber
Table number for table TicketStatus 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 |
LeftOuterJoin_Ejuser_DefaultStatusAddMessage
Generated left outer join from the primary key TicketStatusId on this table, to Ejuser.DefaultStatusAddMessage.
Declaration
public TargetedLeftOuterJoin<EjuserTableInfo> LeftOuterJoin_Ejuser_DefaultStatusAddMessage { get; }
Property Value
Type | Description |
---|---|
TargetedLeftOuterJoin<EjuserTableInfo> |
LeftOuterJoin_Ejuser_DefaultStatusNewTicket
Generated left outer join from the primary key TicketStatusId on this table, to Ejuser.DefaultStatusNewTicket.
Declaration
public TargetedLeftOuterJoin<EjuserTableInfo> LeftOuterJoin_Ejuser_DefaultStatusNewTicket { get; }
Property Value
Type | Description |
---|---|
TargetedLeftOuterJoin<EjuserTableInfo> |
LeftOuterJoin_Ticket_TicketStatus
Generated left outer join from the primary key TicketStatusId on this table, to Ticket.TicketStatus.
Declaration
public TargetedLeftOuterJoin<TicketTableInfo> LeftOuterJoin_Ticket_TicketStatus { get; }
Property Value
Type | Description |
---|---|
TargetedLeftOuterJoin<TicketTableInfo> |
LeftOuterJoin_TicketStatusHistory_TicketStatus
Generated left outer join from the primary key TicketStatusId on this table, to TicketStatusHistory.TicketStatus.
Declaration
public TargetedLeftOuterJoin<TicketStatusHistoryTableInfo> LeftOuterJoin_TicketStatusHistory_TicketStatus { get; }
Property Value
Type | Description |
---|---|
TargetedLeftOuterJoin<TicketStatusHistoryTableInfo> |
Name
Field 'name' in table 'ticket_status': Dictionary type String[256], .NET type: String
Name of user defined ticket status
Declaration
public StringFieldInfo Name { get; }
Property Value
Type | Description |
---|---|
StringFieldInfo |
NoEmailReopen
Field 'no_email_reopen' in table 'ticket_status': Dictionary type Bool, .NET type: Int16
Whether inbound emails can reopen requests with this status or not
Declaration
public UInt16FieldInfo NoEmailReopen { get; }
Property Value
Type | Description |
---|---|
UInt16FieldInfo |
RuntimeDefinition
Definition of the table as described in the deployed runtime dictionary
Declaration
[Obsolete("Use instance property Definition or static member DictionaryTableNumber", true)]
public static SoTable RuntimeDefinition { get; }
Property Value
Type | Description |
---|---|
SoTable |
Status
Field 'status' in table 'ticket_status': Dictionary type Enum, .NET type: TicketBaseStatus
The 'classic' ticket status. I.e. active/closed/postponed/deleted
Declaration
public TicketBaseStatusFieldInfo Status { get; }
Property Value
Type | Description |
---|---|
TicketBaseStatusFieldInfo |
TicketStatusId
Field 'id' in table 'ticket_status': Dictionary type PK, .NET type: Int32
The primary key (auto-incremented)
Declaration
public Int32FieldInfo TicketStatusId { get; }
Property Value
Type | Description |
---|---|
Int32FieldInfo |
TimeCounter
Field 'time_counter' in table 'ticket_status': Dictionary type Enum, .NET type: TicketStatusTimeCounter
Which field in ticket we count time spent on (queue, internal, external)
Declaration
public TicketStatusTimeCounterFieldInfo TimeCounter { get; }
Property Value
Type | Description |
---|---|
TicketStatusTimeCounterFieldInfo |
TsRank
Field 'ts_rank' in table 'ticket_status': Dictionary type Int, .NET type: Int32
Sort order
Declaration
public Int32FieldInfo TsRank { get; }
Property Value
Type | Description |
---|---|
Int32FieldInfo |