Class TicketPriorityTableInfo

Table 'ticket_priority': This table contains the ticket priorities.

Inheritance
Object
TableInfo
TicketPriorityTableInfo
Implements
Inherited Members
Namespace: SuperOffice.CRM.Data
Assembly: SoDataBase.dll
Syntax
[DatabaseTable("ticket_priority")]
public class TicketPriorityTableInfo : 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 TicketPriority in the database dictionary: ticket_priority

Declaration
public const string DictionaryTableName = "ticket_priority"
Field Value
Type Description
String

Properties

ChangedOwner

Field 'changed_owner' in table 'ticket_priority': Dictionary type Enum, .NET type: TicketPriorityEscalateEvent

This field indicates what to do with the escalation chain when the request changes owner (manually)

Declaration
public TicketPriorityEscalateEventFieldInfo ChangedOwner { get; }
Property Value
Type Description
TicketPriorityEscalateEventFieldInfo

Deadline

Field 'deadline' in table 'ticket_priority': Dictionary type Int, .NET type: Int32

Deadline to add if escalated (minutes)

Declaration
public Int32FieldInfo Deadline { get; }
Property Value
Type Description
Int32FieldInfo

Definition

Definition of the table as described in the deployed runtime dictionary

Declaration
public override SoTable Definition { get; }
Property Value
Type Description
SoTable
Overrides

DictionaryTableNumber

Table number for table TicketPriority 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

Flags

Field 'flags' in table 'ticket_priority': Dictionary type Enum, .NET type: TicketPriorityFlags

A bitmask of flags.

Declaration
public TicketPriorityFlagsFieldInfo Flags { get; }
Property Value
Type Description
TicketPriorityFlagsFieldInfo

FriStart

Field 'fri_start' in table 'ticket_priority': Dictionary type DateTime, .NET type: DateTime

Declaration
public DateTimeFieldInfo FriStart { get; }
Property Value
Type Description
DateTimeFieldInfo

FriStop

Field 'fri_stop' in table 'ticket_priority': Dictionary type DateTime, .NET type: DateTime

Declaration
public DateTimeFieldInfo FriStop { get; }
Property Value
Type Description
DateTimeFieldInfo

LeftOuterJoin_ChatTopic_PriorityId

Generated left outer join from the primary key TicketPriorityId on this table, to ChatTopic.PriorityId.

Declaration
public TargetedLeftOuterJoin<ChatTopicTableInfo> LeftOuterJoin_ChatTopic_PriorityId { get; }
Property Value
Type Description
TargetedLeftOuterJoin<ChatTopicTableInfo>

LeftOuterJoin_Contact_TicketPriorityId

Generated left outer join from the primary key TicketPriorityId on this table, to Contact.TicketPriorityId.

Declaration
public TargetedLeftOuterJoin<ContactTableInfo> LeftOuterJoin_Contact_TicketPriorityId { get; }
Property Value
Type Description
TargetedLeftOuterJoin<ContactTableInfo>

LeftOuterJoin_MailInFilter_Priority

Generated left outer join from the primary key TicketPriorityId on this table, to MailInFilter.Priority.

Declaration
public TargetedLeftOuterJoin<MailInFilterTableInfo> LeftOuterJoin_MailInFilter_Priority { get; }
Property Value
Type Description
TargetedLeftOuterJoin<MailInFilterTableInfo>

LeftOuterJoin_MsFilter_NewPriority

Generated left outer join from the primary key TicketPriorityId on this table, to MsFilter.NewPriority.

Declaration
public TargetedLeftOuterJoin<MsFilterTableInfo> LeftOuterJoin_MsFilter_NewPriority { get; }
Property Value
Type Description
TargetedLeftOuterJoin<MsFilterTableInfo>

LeftOuterJoin_Person_TicketPriorityId

Generated left outer join from the primary key TicketPriorityId on this table, to Person.TicketPriorityId.

Declaration
public TargetedLeftOuterJoin<PersonTableInfo> LeftOuterJoin_Person_TicketPriorityId { get; }
Property Value
Type Description
TargetedLeftOuterJoin<PersonTableInfo>

Generated left outer join from the primary key TicketPriorityId on this table, to SLink.TicketPriority.

Declaration
public TargetedLeftOuterJoin<SLinkTableInfo> LeftOuterJoin_SLink_TicketPriority { get; }
Property Value
Type Description
TargetedLeftOuterJoin<SLinkTableInfo>

LeftOuterJoin_Ticket_OrigPriority

Generated left outer join from the primary key TicketPriorityId on this table, to Ticket.OrigPriority.

Declaration
public TargetedLeftOuterJoin<TicketTableInfo> LeftOuterJoin_Ticket_OrigPriority { get; }
Property Value
Type Description
TargetedLeftOuterJoin<TicketTableInfo>

LeftOuterJoin_Ticket_Priority

Generated left outer join from the primary key TicketPriorityId on this table, to Ticket.Priority.

Declaration
public TargetedLeftOuterJoin<TicketTableInfo> LeftOuterJoin_Ticket_Priority { get; }
Property Value
Type Description
TargetedLeftOuterJoin<TicketTableInfo>

LeftOuterJoin_TicketAlert_Priority

Generated left outer join from the primary key TicketPriorityId on this table, to TicketAlert.Priority.

Declaration
public TargetedLeftOuterJoin<TicketAlertTableInfo> LeftOuterJoin_TicketAlert_Priority { get; }
Property Value
Type Description
TargetedLeftOuterJoin<TicketAlertTableInfo>

MonStart

Field 'mon_start' in table 'ticket_priority': Dictionary type DateTime, .NET type: DateTime

When the timeframe starts on monday.

Declaration
public DateTimeFieldInfo MonStart { get; }
Property Value
Type Description
DateTimeFieldInfo

MonStop

Field 'mon_stop' in table 'ticket_priority': Dictionary type DateTime, .NET type: DateTime

When the timeframe ends on monday.

Declaration
public DateTimeFieldInfo MonStop { get; }
Property Value
Type Description
DateTimeFieldInfo

Name

Field 'name' in table 'ticket_priority': Dictionary type String[65], .NET type: String

The name of the priority.

Declaration
public StringFieldInfo Name { get; }
Property Value
Type Description
StringFieldInfo

NonDates

Field 'non_dates' in table 'ticket_priority': Dictionary type String[256], .NET type: String

A comma separated list of dates (dd/mm) which should be excluded from the timeframe.

Declaration
public StringFieldInfo NonDates { get; }
Property Value
Type Description
StringFieldInfo

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

SatStart

Field 'sat_start' in table 'ticket_priority': Dictionary type DateTime, .NET type: DateTime

Declaration
public DateTimeFieldInfo SatStart { get; }
Property Value
Type Description
DateTimeFieldInfo

SatStop

Field 'sat_stop' in table 'ticket_priority': Dictionary type DateTime, .NET type: DateTime

Declaration
public DateTimeFieldInfo SatStop { get; }
Property Value
Type Description
DateTimeFieldInfo

SortOrder

Field 'sort_order' in table 'ticket_priority': Dictionary type Int, .NET type: Int32

Indicates the sort order for this priority. 1 is first, 100 is last

Declaration
public Int32FieldInfo SortOrder { get; }
Property Value
Type Description
Int32FieldInfo

Status

Field 'status' in table 'ticket_priority': Dictionary type Enum, .NET type: TicketPriorityStatus

The status (normal/deleted) of the priority.

Declaration
public TicketPriorityStatusFieldInfo Status { get; }
Property Value
Type Description
TicketPriorityStatusFieldInfo

SunStart

Field 'sun_start' in table 'ticket_priority': Dictionary type DateTime, .NET type: DateTime

Declaration
public DateTimeFieldInfo SunStart { get; }
Property Value
Type Description
DateTimeFieldInfo

SunStop

Field 'sun_stop' in table 'ticket_priority': Dictionary type DateTime, .NET type: DateTime

Declaration
public DateTimeFieldInfo SunStop { get; }
Property Value
Type Description
DateTimeFieldInfo

ThuStart

Field 'thu_start' in table 'ticket_priority': Dictionary type DateTime, .NET type: DateTime

Declaration
public DateTimeFieldInfo ThuStart { get; }
Property Value
Type Description
DateTimeFieldInfo

ThuStop

Field 'thu_stop' in table 'ticket_priority': Dictionary type DateTime, .NET type: DateTime

Declaration
public DateTimeFieldInfo ThuStop { get; }
Property Value
Type Description
DateTimeFieldInfo

TicketChangedPriority

Field 'ticket_changed_priority' in table 'ticket_priority': Dictionary type Enum, .NET type: TicketPriorityEscalateEvent

This field indicates what to do with the escalation chain when the request is changed into this priority

Declaration
public TicketPriorityEscalateEventFieldInfo TicketChangedPriority { get; }
Property Value
Type Description
TicketPriorityEscalateEventFieldInfo

TicketClosed

Field 'ticket_closed' in table 'ticket_priority': Dictionary type Enum, .NET type: TicketPriorityEscalateEvent

This field indicates what to do with the escalation chain when the request is closed

Declaration
public TicketPriorityEscalateEventFieldInfo TicketClosed { get; }
Property Value
Type Description
TicketPriorityEscalateEventFieldInfo

TicketNew

Field 'ticket_new' in table 'ticket_priority': Dictionary type Enum, .NET type: TicketPriorityEscalateEvent

This field indicates what to do with the escalation chain when a new request is registered

Declaration
public TicketPriorityEscalateEventFieldInfo TicketNew { get; }
Property Value
Type Description
TicketPriorityEscalateEventFieldInfo

TicketNewinfo

Field 'ticket_newinfo' in table 'ticket_priority': Dictionary type Enum, .NET type: TicketPriorityEscalateEvent

This field indicates what to do with the escalation chain when the request gets new info

Declaration
public TicketPriorityEscalateEventFieldInfo TicketNewinfo { get; }
Property Value
Type Description
TicketPriorityEscalateEventFieldInfo

TicketPriorityId

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

The primary key (auto-incremented)

Declaration
public Int32FieldInfo TicketPriorityId { get; }
Property Value
Type Description
Int32FieldInfo

TicketRead

Field 'ticket_read' in table 'ticket_priority': Dictionary type Enum, .NET type: TicketPriorityEscalateEvent

This field indicates what to do with the escalation chain when the request is read

Declaration
public TicketPriorityEscalateEventFieldInfo TicketRead { get; }
Property Value
Type Description
TicketPriorityEscalateEventFieldInfo

TueStart

Field 'tue_start' in table 'ticket_priority': Dictionary type DateTime, .NET type: DateTime

Declaration
public DateTimeFieldInfo TueStart { get; }
Property Value
Type Description
DateTimeFieldInfo

TueStop

Field 'tue_stop' in table 'ticket_priority': Dictionary type DateTime, .NET type: DateTime

Declaration
public DateTimeFieldInfo TueStop { get; }
Property Value
Type Description
DateTimeFieldInfo

WedStart

Field 'wed_start' in table 'ticket_priority': Dictionary type DateTime, .NET type: DateTime

Declaration
public DateTimeFieldInfo WedStart { get; }
Property Value
Type Description
DateTimeFieldInfo

WedStop

Field 'wed_stop' in table 'ticket_priority': Dictionary type DateTime, .NET type: DateTime

Declaration
public DateTimeFieldInfo WedStop { get; }
Property Value
Type Description
DateTimeFieldInfo

Implements

Extension Methods

EnumUtil.MapEnums<From, To>(From)