Class SLinkTableInfo
Table 's_link': Links in messages to measure success rate of a campaign.
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 |
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 takenDeclaration
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 personDeclaration
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 toDeclaration
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 personDeclaration
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 memberDeclaration
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 toDeclaration
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
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 linkDeclaration
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 fieldDeclaration
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 rootDeclaration
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 toDeclaration
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 messageDeclaration
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 linkDeclaration
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 usedDeclaration
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 messageDeclaration
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 linkDeclaration
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 whenDeclaration
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 whomDeclaration
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 personDeclaration
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 fromDeclaration
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 fromDeclaration
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 personDeclaration
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 memberDeclaration
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 runDeclaration
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 keyDeclaration
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 shipmentDeclaration
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 minutesDeclaration
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 createdDeclaration
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 taskDeclaration
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 0Declaration
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 specifiedDeclaration
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 createdDeclaration
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 whenDeclaration
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 whomDeclaration
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 recordDeclaration
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