Class SLinkTableInfo

Table 's_link': Links in messages to measure success rate of a campaign.

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

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

Properties

ActionFlags

Field 'action_flags' in table 's_link': Dictionary type Enum, .NET type: ShipmentLinkAction

Bitmask defining what action should be taken

Declaration
public ShipmentLinkActionFieldInfo ActionFlags { get; }
Property Value
Type Description
ShipmentLinkActionFieldInfo

AddContactInterest

Field 'add_contact_interest' in table 's_link': Dictionary type FK, .NET type: Int32

Contact interest to add to recipient person

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

AddContactInterest_InnerJoin_ContInt

Generated join from the foreign key AddContactInterest in this table, to its target table ContIntTableInfo.

Declaration
public TargetedInnerJoin<ContIntTableInfo> AddContactInterest_InnerJoin_ContInt { get; }
Property Value
Type Description
TargetedInnerJoin<ContIntTableInfo>

AddContactSelection

Field 'add_contact_selection' in table 's_link': Dictionary type FK, .NET type: Int32

Static contact selection to add person to

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

AddContactSelection_InnerJoin_Selection

Generated join from the foreign key AddContactSelection in this table, to its target table SelectionTableInfo.

Declaration
public TargetedInnerJoin<SelectionTableInfo> AddContactSelection_InnerJoin_Selection { get; }
Property Value
Type Description
TargetedInnerJoin<SelectionTableInfo>

AddPersonInterest

Field 'add_person_interest' in table 's_link': Dictionary type FK, .NET type: Int32

Person interest to add to recipient person

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

AddPersonInterest_InnerJoin_PersInt

Generated join from the foreign key AddPersonInterest in this table, to its target table PersIntTableInfo.

Declaration
public TargetedInnerJoin<PersIntTableInfo> AddPersonInterest_InnerJoin_PersInt { get; }
Property Value
Type Description
TargetedInnerJoin<PersIntTableInfo>

AddProject

Field 'add_project' in table 's_link': Dictionary type FK, .NET type: Int32

Project to add person to, as member

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

AddProject_InnerJoin_Project

Generated join from the foreign key AddProject in this table, to its target table ProjectTableInfo.

Declaration
public TargetedInnerJoin<ProjectTableInfo> AddProject_InnerJoin_Project { get; }
Property Value
Type Description
TargetedInnerJoin<ProjectTableInfo>

AddToSelection

Field 'add_to_selection' in table 's_link': Dictionary type FK, .NET type: Int32

The id of the selection that the customer shall be added to

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

AddToSelection_InnerJoin_Ejselection

Generated join from the foreign key AddToSelection in this table, to its target table EjselectionTableInfo.

Declaration
public TargetedInnerJoin<EjselectionTableInfo> AddToSelection_InnerJoin_Ejselection { get; }
Property Value
Type Description
TargetedInnerJoin<EjselectionTableInfo>

Definition

Definition of the table as described in the deployed runtime dictionary

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

Description

Field 'description' in table 's_link': Dictionary type String[256], .NET type: String

A short description of this link

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

DictionaryTableNumber

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

ExtraField

Field 'extra_field' in table 's_link': Dictionary type String[256], .NET type: String

The name of the extra field to set if the customer clicks a link. empty if no extra field

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

FolderId

Field 'folder_id' in table 's_link': Dictionary type Int, .NET type: Int32

The folder which this link belongs to. -1 indicates that the link is on the root

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

Hits

Field 'hits' in table 's_link': Dictionary type Int, .NET type: Int32

Number of clicks on this link

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

LastReset

Field 'last_reset' in table 's_link': Dictionary type DateTime, .NET type: DateTime

The time of last reset.

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

LeftOuterJoin_SLinkCustomer_LinkId

Generated left outer join from the primary key SLinkId on this table, to SLinkCustomer.LinkId.

Declaration
public TargetedLeftOuterJoin<SLinkCustomerTableInfo> LeftOuterJoin_SLinkCustomer_LinkId { get; }
Property Value
Type Description
TargetedLeftOuterJoin<SLinkCustomerTableInfo>

LeftOuterJoin_SLinkCustomerStatical_LinkId

Generated left outer join from the primary key SLinkId on this table, to SLinkCustomerStatical.LinkId.

Declaration
public TargetedLeftOuterJoin<SLinkCustomerStaticalTableInfo> LeftOuterJoin_SLinkCustomerStatical_LinkId { get; }
Property Value
Type Description
TargetedLeftOuterJoin<SLinkCustomerStaticalTableInfo>

LinkValue

Field 'value' in table 's_link': Dictionary type String[256], .NET type: String

The value of the extra field to set if the customer clicks a link.

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

RedirectIsUrl

Field 'redirect_is_url' in table 's_link': Dictionary type Bool, .NET type: Int16

1 if url is used, 0 if custom text is used.

Declaration
public UInt16FieldInfo RedirectIsUrl { get; }
Property Value
Type Description
UInt16FieldInfo

Registered

Field 'registered' in table 's_link': Dictionary type UtcDateTime, .NET type: DateTime

Registered when

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

RegisteredAssociateId

Field 'registered_associate_id' in table 's_link': Dictionary type FK, .NET type: Int32

Registered by whom

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

RegisteredAssociateId_InnerJoin_Associate

Generated join from the foreign key RegisteredAssociateId in this table, to its target table AssociateTableInfo.

Declaration
public TargetedInnerJoin<AssociateTableInfo> RegisteredAssociateId_InnerJoin_Associate { get; }
Property Value
Type Description
TargetedInnerJoin<AssociateTableInfo>

RemoveContactInterest

Field 'remove_contact_interest' in table 's_link': Dictionary type FK, .NET type: Int32

Person interest to remove from recipient person

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

RemoveContactInterest_InnerJoin_ContInt

Generated join from the foreign key RemoveContactInterest in this table, to its target table ContIntTableInfo.

Declaration
public TargetedInnerJoin<ContIntTableInfo> RemoveContactInterest_InnerJoin_ContInt { get; }
Property Value
Type Description
TargetedInnerJoin<ContIntTableInfo>

RemoveContactSelection

Field 'remove_contact_selection' in table 's_link': Dictionary type FK, .NET type: Int32

Static contact selection to remove person from

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

RemoveContactSelection_InnerJoin_Selection

Generated join from the foreign key RemoveContactSelection in this table, to its target table SelectionTableInfo.

Declaration
public TargetedInnerJoin<SelectionTableInfo> RemoveContactSelection_InnerJoin_Selection { get; }
Property Value
Type Description
TargetedInnerJoin<SelectionTableInfo>

RemoveFromSelection

Field 'remove_from_selection' in table 's_link': Dictionary type FK, .NET type: Int32

The id of the selection that the customer shall be removed from

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

RemoveFromSelection_InnerJoin_Ejselection

Generated join from the foreign key RemoveFromSelection in this table, to its target table EjselectionTableInfo.

Declaration
public TargetedInnerJoin<EjselectionTableInfo> RemoveFromSelection_InnerJoin_Ejselection { get; }
Property Value
Type Description
TargetedInnerJoin<EjselectionTableInfo>

RemovePersonInterest

Field 'remove_person_interest' in table 's_link': Dictionary type FK, .NET type: Int32

Person interest to remove from recipient person

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

RemovePersonInterest_InnerJoin_PersInt

Generated join from the foreign key RemovePersonInterest in this table, to its target table PersIntTableInfo.

Declaration
public TargetedInnerJoin<PersIntTableInfo> RemovePersonInterest_InnerJoin_PersInt { get; }
Property Value
Type Description
TargetedInnerJoin<PersIntTableInfo>

RemoveProject

Field 'remove_project' in table 's_link': Dictionary type FK, .NET type: Int32

Project to remove person from, as member

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

RemoveProject_InnerJoin_Project

Generated join from the foreign key RemoveProject in this table, to its target table ProjectTableInfo.

Declaration
public TargetedInnerJoin<ProjectTableInfo> RemoveProject_InnerJoin_Project { get; }
Property Value
Type Description
TargetedInnerJoin<ProjectTableInfo>

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

ScriptId

Field 'script_id' in table 's_link': Dictionary type FK, .NET type: Int32

The ejScript which will be run when the link is clicked. -1 means no script is run

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

ScriptId_InnerJoin_Ejscript

Generated join from the foreign key ScriptId in this table, to its target table EjscriptTableInfo.

Declaration
public TargetedInnerJoin<EjscriptTableInfo> ScriptId_InnerJoin_Ejscript { get; }
Property Value
Type Description
TargetedInnerJoin<EjscriptTableInfo>

SLinkId

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

Primary key

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

Status

Field 'status' in table 's_link': Dictionary type Enum, .NET type: Int16

Deleted or not. Deleted links should still work.

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

TaskAssociateId

Field 'task_associate_id' in table 's_link': Dictionary type FK, .NET type: Int32

Associate whose diary should receive the task or assignment (unless AssignToOurContact is specified)

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

TaskAssociateId_InnerJoin_Associate

Generated join from the foreign key TaskAssociateId in this table, to its target table AssociateTableInfo.

Declaration
public TargetedInnerJoin<AssociateTableInfo> TaskAssociateId_InnerJoin_Associate { get; }
Property Value
Type Description
TargetedInnerJoin<AssociateTableInfo>

TaskCreatingAssociateId

Field 'task_creating_associate_id' in table 's_link': Dictionary type FK, .NET type: Int32

Associate who should stand as creator of task; also works as fallback if an assigned task is rejected. Usually the associate who ordered the shipment

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

TaskCreatingAssociateId_InnerJoin_Associate

Generated join from the foreign key TaskCreatingAssociateId in this table, to its target table AssociateTableInfo.

Declaration
public TargetedInnerJoin<AssociateTableInfo> TaskCreatingAssociateId_InnerJoin_Associate { get; }
Property Value
Type Description
TargetedInnerJoin<AssociateTableInfo>

TaskDuration

Field 'task_duration' in table 's_link': Dictionary type Int, .NET type: Int32

Task duration in minutes

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

TaskFlags

Field 'task_flags' in table 's_link': Dictionary type Enum, .NET type: ShipmentLinkTaskFlags

Flags that control how the task is created

Declaration
public ShipmentLinkTaskFlagsFieldInfo TaskFlags { get; }
Property Value
Type Description
ShipmentLinkTaskFlagsFieldInfo

TaskIdx

Field 'task_idx' in table 's_link': Dictionary type FK, .NET type: Int32

Task type of new task

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

TaskIdx_InnerJoin_Task

Generated join from the foreign key TaskIdx in this table, to its target table TaskTableInfo.

Declaration
public TargetedInnerJoin<TaskTableInfo> TaskIdx_InnerJoin_Task { get; }
Property Value
Type Description
TargetedInnerJoin<TaskTableInfo>

TaskProject

Field 'task_project' in table 's_link': Dictionary type FK, .NET type: Int32

Project to connect task to, can be 0

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

TaskProject_InnerJoin_Project

Generated join from the foreign key TaskProject in this table, to its target table ProjectTableInfo.

Declaration
public TargetedInnerJoin<ProjectTableInfo> TaskProject_InnerJoin_Project { get; }
Property Value
Type Description
TargetedInnerJoin<ProjectTableInfo>

TaskStart

Field 'task_start' in table 's_link': Dictionary type DateTime, .NET type: DateTime

Start time of task, unless UseNextAvailableTime is specified

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

TaskText

Field 'task_text' in table 's_link': Dictionary type String[2048], .NET type: String

Text of task to be created

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

TemplateText

Field 'template_text' in table 's_link': Dictionary type Clob, .NET type: String

Text to print when link is clicked.

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

TicketCategory

Field 'ticket_category' in table 's_link': Dictionary type FK, .NET type: Int32

The id of the category a ticket is in.

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

TicketCategory_InnerJoin_EjCategory

Generated join from the foreign key TicketCategory in this table, to its target table EjCategoryTableInfo.

Declaration
public TargetedInnerJoin<EjCategoryTableInfo> TicketCategory_InnerJoin_EjCategory { get; }
Property Value
Type Description
TargetedInnerJoin<EjCategoryTableInfo>

TicketOwnedBy

Field 'ticket_owned_by' in table 's_link': Dictionary type FK, .NET type: Int32

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

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

TicketOwnedBy_InnerJoin_Ejuser

Generated join from the foreign key TicketOwnedBy in this table, to its target table EjuserTableInfo.

Declaration
public TargetedInnerJoin<EjuserTableInfo> TicketOwnedBy_InnerJoin_Ejuser { get; }
Property Value
Type Description
TargetedInnerJoin<EjuserTableInfo>

TicketPriority

Field 'ticket_priority' in table 's_link': Dictionary type FK, .NET type: Int32

The reference to the ticket_priority table.

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

TicketPriority_InnerJoin_TicketPriority

Generated join from the foreign key TicketPriority in this table, to its target table TicketPriorityTableInfo.

Declaration
public TargetedInnerJoin<TicketPriorityTableInfo> TicketPriority_InnerJoin_TicketPriority { get; }
Property Value
Type Description
TargetedInnerJoin<TicketPriorityTableInfo>

TicketTitle

Field 'ticket_title' in table 's_link': Dictionary type String[256], .NET type: String

The title on the ticket if the clicks results in creating a request.

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

Updated

Field 'updated' in table 's_link': Dictionary type UtcDateTime, .NET type: DateTime

Last updated when

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

UpdatedAssociateId

Field 'updated_associate_id' in table 's_link': Dictionary type FK, .NET type: Int32

Last updated by whom

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

UpdatedAssociateId_InnerJoin_Associate

Generated join from the foreign key UpdatedAssociateId in this table, to its target table AssociateTableInfo.

Declaration
public TargetedInnerJoin<AssociateTableInfo> UpdatedAssociateId_InnerJoin_Associate { get; }
Property Value
Type Description
TargetedInnerJoin<AssociateTableInfo>

UpdatedCount

Field 'updatedCount' in table 's_link': Dictionary type UShort, .NET type: Int16

Number of updates made to this record

Declaration
public UInt16FieldInfo UpdatedCount { get; }
Property Value
Type Description
UInt16FieldInfo

Url

Field 'url' in table 's_link': Dictionary type String[256], .NET type: String

The real URL of this link (www.vg.no etc)

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

Implements

Extension Methods

EnumUtil.MapEnums<From, To>(From)