Show / Hide Table of Contents

Class SLinkTableInfo

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

Inheritance
Object
TableInfo
SLinkTableInfo
Implements
ICloneable
Inherited Members
TableInfo.ToString()
TableInfo.RegisterFields(FieldInfo[])
TableInfo.FieldInfoFromSoField(SoField)
TableInfo.Clone()
TableInfo.IsSameTable(TableInfo)
TableInfo.FindField(String)
TableInfo.ProtAll
TableInfo.HashCheckFields
TableInfo.TableName
TableInfo.DbName
TableInfo.IsDictionaryTable
TableInfo.All
TableInfo.Item[String]
TableInfo.PrimaryKeyField
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
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 .

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
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 .

AddContactInterest

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

Contact interest to add to recipient person
Declaration
public Int32FieldInfo AddContactInterest { get; }
Property Value
Type Description
Int32FieldInfo
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 .

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>
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 .

AddContactSelection

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

Static contact selection to add person to
Declaration
public Int32FieldInfo AddContactSelection { get; }
Property Value
Type Description
Int32FieldInfo
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 .

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>
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 .

AddPersonInterest

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

Person interest to add to recipient person
Declaration
public Int32FieldInfo AddPersonInterest { get; }
Property Value
Type Description
Int32FieldInfo
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 .

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>
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 .

AddProject

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

Project to add person to, as member
Declaration
public Int32FieldInfo AddProject { get; }
Property Value
Type Description
Int32FieldInfo
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 .

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>
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 .

AddToSelection

Field 'add_to_selection' in table 's_link': Dictionary type FK, target: Ejselection, .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
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 .

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>
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 .

Definition

Definition of the table as described in the deployed runtime dictionary

Declaration
public override SoTable Definition { get; }
Property Value
Type Description
SoTable
Overrides
TableInfo.Definition
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 .

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
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 .

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
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 .

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
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 .

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
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 .

FormId

Field 'form_id' in table 's_link': Dictionary type FK, target: Form, .NET type: Int32

Relation to the form this link redirects to
Declaration
public Int32FieldInfo FormId { get; }
Property Value
Type Description
Int32FieldInfo
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 .

FormId_InnerJoin_Form

Generated join from the foreign key FormId in this table, to its target table FormTableInfo.

Declaration
public TargetedInnerJoin<FormTableInfo> FormId_InnerJoin_Form { get; }
Property Value
Type Description
TargetedInnerJoin<FormTableInfo>
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 .

FormParameters

Field 'form_parameters' in table 's_link': Dictionary type String[4001], .NET type: String

Contains url parameters that will be added when link is inserted in message
Declaration
public StringFieldInfo FormParameters { get; }
Property Value
Type Description
StringFieldInfo
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 .

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
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 .

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
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 .

LeftOuterJoin_EmailFlowContentLink_SLinkId

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

Declaration
public TargetedLeftOuterJoin<EmailFlowContentLinkTableInfo> LeftOuterJoin_EmailFlowContentLink_SLinkId { get; }
Property Value
Type Description
TargetedLeftOuterJoin<EmailFlowContentLinkTableInfo>
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 .

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>
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 .

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>
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 .

LinkParameters

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

Contains parameters that will be added to the link when it is used
Declaration
public StringFieldInfo LinkParameters { get; }
Property Value
Type Description
StringFieldInfo
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 .

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
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 .

LocalLink

Field 'local_link' in table 's_link': Dictionary type FK, target: SMessage, .NET type: Int32

If this references a shipment message, then this is a local link belonging to that message
Declaration
public Int32FieldInfo LocalLink { get; }
Property Value
Type Description
Int32FieldInfo
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 .

LocalLink_InnerJoin_SMessage

Generated join from the foreign key LocalLink in this table, to its target table SMessageTableInfo.

Declaration
public TargetedInnerJoin<SMessageTableInfo> LocalLink_InnerJoin_SMessage { get; }
Property Value
Type Description
TargetedInnerJoin<SMessageTableInfo>
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 .

RedirectKind

Field 'redirect_kind' in table 's_link': Dictionary type Enum, .NET type: ShipmentLinkRedirectKind

Enum defining the redirect kind (show text, url, etc) of the link
Declaration
public ShipmentLinkRedirectKindFieldInfo RedirectKind { get; }
Property Value
Type Description
ShipmentLinkRedirectKindFieldInfo
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 .

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
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 .

RegisteredAssociateId

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

Registered by whom
Declaration
public Int32FieldInfo RegisteredAssociateId { get; }
Property Value
Type Description
Int32FieldInfo
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 .

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>
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 .

RemoveContactInterest

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

Person interest to remove from recipient person
Declaration
public Int32FieldInfo RemoveContactInterest { get; }
Property Value
Type Description
Int32FieldInfo
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 .

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>
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 .

RemoveContactSelection

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

Static contact selection to remove person from
Declaration
public Int32FieldInfo RemoveContactSelection { get; }
Property Value
Type Description
Int32FieldInfo
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 .

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>
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 .

RemoveFromSelection

Field 'remove_from_selection' in table 's_link': Dictionary type FK, target: Ejselection, .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
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 .

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>
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 .

RemovePersonInterest

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

Person interest to remove from recipient person
Declaration
public Int32FieldInfo RemovePersonInterest { get; }
Property Value
Type Description
Int32FieldInfo
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 .

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>
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 .

RemoveProject

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

Project to remove person from, as member
Declaration
public Int32FieldInfo RemoveProject { get; }
Property Value
Type Description
Int32FieldInfo
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 .

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>
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 .

RuntimeDefinition

Definition of the table as described in the deployed runtime dictionary

Declaration
public static SoTable RuntimeDefinition { get; }
Property Value
Type Description
SoTable
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 .

ScriptId

Field 'script_id' in table 's_link': Dictionary type FK, target: Ejscript, .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
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 .

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>
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 .

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
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 .

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
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 .

TaskAssociateId

Field 'task_associate_id' in table 's_link': Dictionary type FK, target: Associate, .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
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 .

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>
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 .

TaskCreatingAssociateId

Field 'task_creating_associate_id' in table 's_link': Dictionary type FK, target: Associate, .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
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 .

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>
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 .

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
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 .

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
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 .

TaskIdx

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

Task type of new task
Declaration
public Int32FieldInfo TaskIdx { get; }
Property Value
Type Description
Int32FieldInfo
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 .

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>
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 .

TaskProject

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

Project to connect task to, can be 0
Declaration
public Int32FieldInfo TaskProject { get; }
Property Value
Type Description
Int32FieldInfo
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 .

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>
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 .

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
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 .

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
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 .

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
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 .

TicketCategory

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

The id of the category a ticket is in.
Declaration
public Int32FieldInfo TicketCategory { get; }
Property Value
Type Description
Int32FieldInfo
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 .

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>
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 .

TicketOwnedBy

Field 'ticket_owned_by' in table 's_link': Dictionary type FK, target: Ejuser, .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
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 .

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>
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 .

TicketPriority

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

The reference to the ticket_priority table.
Declaration
public Int32FieldInfo TicketPriority { get; }
Property Value
Type Description
Int32FieldInfo
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 .

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>
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 .

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
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 .

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
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 .

UpdatedAssociateId

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

Last updated by whom
Declaration
public Int32FieldInfo UpdatedAssociateId { get; }
Property Value
Type Description
Int32FieldInfo
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 .

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>
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 .

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
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 .

Url

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

The real URL of this link (www.vg.no etc)
Declaration
public StringFieldInfo Url { get; }
Property Value
Type Description
StringFieldInfo
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 .

Implements

System.ICloneable

Extension Methods

EnumUtil.MapEnums<From, To>(From)
Converters.MapEnums<From, To>(From)
© SuperOffice. All rights reserved.
SuperOffice |  Community |  Release Notes |  Privacy |  Site feedback |  Search Docs |  About Docs |  Contribute |  Back to top