Class SelectionTableInfo

Table 'selection': Selections

Inheritance

object

TableInfo

SelectionTableInfo

Implements

ICloneable

Inherited Members

TableInfo.ToString()

TableInfo.RegisterFields(params FieldInfo[])

TableInfo.FieldInfoFromSoField(SoField)

TableInfo.Clone()

TableInfo.IsSameTable(TableInfo)

TableInfo.FindField(string)

TableInfo.ProtAll

TableInfo.UseNolockIfPossible

TableInfo.HashCheckFields

TableInfo.TableName

TableInfo.DbName

TableInfo.IsDictionaryTable

TableInfo.All

TableInfo.this[string]

TableInfo.PrimaryKeyField

object.Equals(object)

object.Equals(object, object)

object.ReferenceEquals(object, object)

object.GetHashCode()

object.GetType()

object.MemberwiseClone()

Namespace: SuperOffice.CRM.Data

Assembly: SoDataBase.dll

Syntax

[DatabaseTable("selection")]
public class SelectionTableInfo : 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 TablesInfo.GetSelectionInfo().

Fields

DictionaryTableName

Conceptual name of table Selection in the database dictionary: selection

Declaration

public const string DictionaryTableName = "selection"

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 TablesInfo.GetSelectionInfo().

Properties

AssociateId

Field 'associate_id' in table 'selection': Dictionary type FK, target: Associate, .NET type: int

Associate who owns the selection

Declaration

public Int32FieldInfo AssociateId { 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 TablesInfo.GetSelectionInfo().

AssociateId_InnerJoin_Associate

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

Declaration

public TargetedInnerJoin<AssociateTableInfo> AssociateId_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 TablesInfo.GetSelectionInfo().

ChartKey

Field 'chartKey' in table 'selection': Dictionary type String[255], .NET type: string

ID/key of the last-used chart tile on this selection

Declaration

public StringFieldInfo ChartKey { 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 TablesInfo.GetSelectionInfo().

CombinationType

Field 'combinationType' in table 'selection': Dictionary type Enum, .NET type: SelectionUnionType

How should the inputs of a combined selection be combined

Declaration

public SelectionUnionTypeFieldInfo CombinationType { get; }

Property Value

Type	Description
SelectionUnionTypeFieldInfo

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 TablesInfo.GetSelectionInfo().

CompanyUnique

Field 'companyUnique' in table 'selection': Dictionary type UShort, .NET type: short

Only one person from a company may be selected as a member

Declaration

public UInt16FieldInfo CompanyUnique { 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 TablesInfo.GetSelectionInfo().

DashboardTileDefinitionId

Field 'dashboard_tile_definition_id' in table 'selection': Dictionary type FK, target: DashboardTileDefinition, .NET type: int

The associated tile definition

Declaration

public Int32FieldInfo DashboardTileDefinitionId { 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 TablesInfo.GetSelectionInfo().

DashboardTileDefinitionId_InnerJoin_DashboardTileDefinition

Generated join from the foreign key DashboardTileDefinitionId in this table, to its target table DashboardTileDefinitionTableInfo.

Declaration

public TargetedInnerJoin<DashboardTileDefinitionTableInfo> DashboardTileDefinitionId_InnerJoin_DashboardTileDefinition { get; }

Property Value

Type	Description
TargetedInnerJoin<DashboardTileDefinitionTableInfo>

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 TablesInfo.GetSelectionInfo().

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 TablesInfo.GetSelectionInfo().

DictionaryTableNumber

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

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 TablesInfo.GetSelectionInfo().

Done

Field 'done' in table 'selection': Dictionary type Bool, .NET type: short

Done (0=false, 1=true). Status implies changes in which fields are shown in GUI, as well as which fields can be updated

Declaration

public UInt16FieldInfo Done { 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 TablesInfo.GetSelectionInfo().

GroupIdx

Field 'group_idx' in table 'selection': Dictionary type FK, target: UserGroup, .NET type: int

Original primary user group of associate

Declaration

public Int32FieldInfo GroupIdx { 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 TablesInfo.GetSelectionInfo().

GroupIdx_InnerJoin_UserGroup

Generated join from the foreign key GroupIdx in this table, to its target table UserGroupTableInfo.

Declaration

public TargetedInnerJoin<UserGroupTableInfo> GroupIdx_InnerJoin_UserGroup { get; }

Property Value

Type	Description
TargetedInnerJoin<UserGroupTableInfo>

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 TablesInfo.GetSelectionInfo().

IncludePerson

Field 'includePerson' in table 'selection': Dictionary type Int, .NET type: int

0 = Include first person, 1 = Include all persons, 2 = Include no persons

Declaration

public Int32FieldInfo IncludePerson { 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 TablesInfo.GetSelectionInfo().

LastLoaded

Field 'lastLoaded' in table 'selection': Dictionary type DateTime, .NET type: DateTime

The date/time this selection was last loaded (selectionentity fetched)

Declaration

public DateTimeFieldInfo LastLoaded { 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 TablesInfo.GetSelectionInfo().

LastLoadedBy

Field 'lastLoadedBy' in table 'selection': Dictionary type FK, target: Associate, .NET type: int

Who last loaded this selection

Declaration

public Int32FieldInfo LastLoadedBy { 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 TablesInfo.GetSelectionInfo().

LastLoadedBy_InnerJoin_Associate

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

Declaration

public TargetedInnerJoin<AssociateTableInfo> LastLoadedBy_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 TablesInfo.GetSelectionInfo().

LastMembershipChange

Field 'lastMembershipChange' in table 'selection': Dictionary type DateTime, .NET type: DateTime

The date/time the membership the selection last changed. Dynamic: change of criteria; Static: add/remove members; Combined: change of algorithm

Declaration

public DateTimeFieldInfo LastMembershipChange { 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 TablesInfo.GetSelectionInfo().

LastMembershipChangeBy

Field 'lastMembershipChangeBy' in table 'selection': Dictionary type FK, target: Associate, .NET type: int

Who last changed the membership

Declaration

public Int32FieldInfo LastMembershipChangeBy { 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 TablesInfo.GetSelectionInfo().

LastMembershipChangeBy_InnerJoin_Associate

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

Declaration

public TargetedInnerJoin<AssociateTableInfo> LastMembershipChangeBy_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 TablesInfo.GetSelectionInfo().

LeftOuterJoin_BoardViewSettings_SelectionId

Generated left outer join from the primary key SelectionId on this table, to BoardViewSettings.SelectionId.

Declaration

public TargetedLeftOuterJoin<BoardViewSettingsTableInfo> LeftOuterJoin_BoardViewSettings_SelectionId { get; }

Property Value

Type	Description
TargetedLeftOuterJoin<BoardViewSettingsTableInfo>

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 TablesInfo.GetSelectionInfo().

LeftOuterJoin_DashboardTileDefinition_SecondarySelectionId

Generated left outer join from the primary key SelectionId on this table, to DashboardTileDefinition.SecondarySelectionId.

Declaration

public TargetedLeftOuterJoin<DashboardTileDefinitionTableInfo> LeftOuterJoin_DashboardTileDefinition_SecondarySelectionId { get; }

Property Value

Type	Description
TargetedLeftOuterJoin<DashboardTileDefinitionTableInfo>

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 TablesInfo.GetSelectionInfo().

LeftOuterJoin_DashboardTileDefinition_SelectionId

Generated left outer join from the primary key SelectionId on this table, to DashboardTileDefinition.SelectionId.

Declaration

public TargetedLeftOuterJoin<DashboardTileDefinitionTableInfo> LeftOuterJoin_DashboardTileDefinition_SelectionId { get; }

Property Value

Type	Description
TargetedLeftOuterJoin<DashboardTileDefinitionTableInfo>

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 TablesInfo.GetSelectionInfo().

LeftOuterJoin_SLink_AddContactSelection

Generated left outer join from the primary key SelectionId on this table, to SLink.AddContactSelection.

Declaration

public TargetedLeftOuterJoin<SLinkTableInfo> LeftOuterJoin_SLink_AddContactSelection { get; }

Property Value

Type	Description
TargetedLeftOuterJoin<SLinkTableInfo>

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 TablesInfo.GetSelectionInfo().

LeftOuterJoin_SLink_RemoveContactSelection

Generated left outer join from the primary key SelectionId on this table, to SLink.RemoveContactSelection.

Declaration

public TargetedLeftOuterJoin<SLinkTableInfo> LeftOuterJoin_SLink_RemoveContactSelection { get; }

Property Value

Type	Description
TargetedLeftOuterJoin<SLinkTableInfo>

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 TablesInfo.GetSelectionInfo().

LeftOuterJoin_SShipment_SelectionId

Generated left outer join from the primary key SelectionId on this table, to SShipment.SelectionId.

Declaration

public TargetedLeftOuterJoin<SShipmentTableInfo> LeftOuterJoin_SShipment_SelectionId { get; }

Property Value

Type	Description
TargetedLeftOuterJoin<SShipmentTableInfo>

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 TablesInfo.GetSelectionInfo().

LeftOuterJoin_SelectionMember_SelectionId

Generated left outer join from the primary key SelectionId on this table, to SelectionMember.SelectionId.

Declaration

public TargetedLeftOuterJoin<SelectionMemberTableInfo> LeftOuterJoin_SelectionMember_SelectionId { get; }

Property Value

Type	Description
TargetedLeftOuterJoin<SelectionMemberTableInfo>

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 TablesInfo.GetSelectionInfo().

LeftOuterJoin_VisibleFor_SelectionId

Generated left outer join from the primary key SelectionId on this table, to VisibleFor.SelectionId.

Declaration

public TargetedLeftOuterJoin<VisibleForTableInfo> LeftOuterJoin_VisibleFor_SelectionId { get; }

Property Value

Type	Description
TargetedLeftOuterJoin<VisibleForTableInfo>

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 TablesInfo.GetSelectionInfo().

LeftSelectionId

Field 'leftSelectionId' in table 'selection': Dictionary type FK, target: Selection, .NET type: int

ID of the left selection of a combined selection

Declaration

public Int32FieldInfo LeftSelectionId { 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 TablesInfo.GetSelectionInfo().

LeftSelectionId_InnerJoin_Selection

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

Declaration

public TargetedInnerJoin<SelectionTableInfo> LeftSelectionId_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 TablesInfo.GetSelectionInfo().

MemberCount

Field 'memberCount' in table 'selection': Dictionary type UInt, .NET type: uint

How many selectionmembers (for progress bar)

Declaration

public FieldInfo MemberCount { get; }

Property Value

Type	Description
FieldInfo

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 TablesInfo.GetSelectionInfo().

Name

Field 'name' in table 'selection': Dictionary type String[220], .NET type: string

Name, freetext indexed

Declaration

public StringFieldInfo Name { 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 TablesInfo.GetSelectionInfo().

PostitTextId

Field 'postitText_Id' in table 'selection': Dictionary type FK, target: Text, .NET type: int

Postit text

Declaration

public Int32FieldInfo PostitTextId { 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 TablesInfo.GetSelectionInfo().

PostitTextId_InnerJoin_Text

Generated join from the foreign key PostitTextId in this table, to its target table TextTableInfo.

Declaration

public TargetedInnerJoin<TextTableInfo> PostitTextId_InnerJoin_Text { get; }

Property Value

Type	Description
TargetedInnerJoin<TextTableInfo>

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 TablesInfo.GetSelectionInfo().

Registered

Field 'registered' in table 'selection': 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 TablesInfo.GetSelectionInfo().

RegisteredAssociateId

Field 'registered_associate_id' in table 'selection': Dictionary type FK, target: Associate, .NET type: int

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 TablesInfo.GetSelectionInfo().

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 TablesInfo.GetSelectionInfo().

RightSelectionId

Field 'rightSelectionId' in table 'selection': Dictionary type FK, target: Selection, .NET type: int

ID of the right selection of a combined selection

Declaration

public Int32FieldInfo RightSelectionId { 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 TablesInfo.GetSelectionInfo().

RightSelectionId_InnerJoin_Selection

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

Declaration

public TargetedInnerJoin<SelectionTableInfo> RightSelectionId_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 TablesInfo.GetSelectionInfo().

RuntimeDefinition

Definition of the table as described in the deployed runtime dictionary

Declaration

[Obsolete("Use instance property Definition or static member DictionaryTableNumber", true)]
public static SoTable RuntimeDefinition { get; }

Property Value

Type	Description
SoTable

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 TablesInfo.GetSelectionInfo().

SearchCatId

Field 'searchCat_id' in table 'selection': Dictionary type FK, target: SearchCat, .NET type: int

Search category (list)

Declaration

public Int32FieldInfo SearchCatId { 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 TablesInfo.GetSelectionInfo().

SearchCatId_InnerJoin_SearchCat

Generated join from the foreign key SearchCatId in this table, to its target table SearchCatTableInfo.

Declaration

public TargetedInnerJoin<SearchCatTableInfo> SearchCatId_InnerJoin_SearchCat { get; }

Property Value

Type	Description
TargetedInnerJoin<SearchCatTableInfo>

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 TablesInfo.GetSelectionInfo().

SelectionId

Field 'selection_id' in table 'selection': Dictionary type PK, .NET type: int

Primary key

Declaration

public Int32FieldInfo SelectionId { 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 TablesInfo.GetSelectionInfo().

Seltype

Field 'seltype' in table 'selection': Dictionary type UShort, .NET type: short

0 = static selection, 1 = dynamic selection, 2 = combined selection. See the 'SystemType' field to disnguish between user selections, and Temporary or other system-managed kinds of selection

Declaration

public UInt16FieldInfo Seltype { 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 TablesInfo.GetSelectionInfo().

SoundEx

Field 'soundEx' in table 'selection': Dictionary type String[10], .NET type: string

What the name sounds like, for duplicate detection

Declaration

public StringFieldInfo SoundEx { 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 TablesInfo.GetSelectionInfo().

Source

Field 'source' in table 'selection': Dictionary type UShort, .NET type: short

How did we get this selection? For future integration needs

Declaration

public UInt16FieldInfo Source { 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 TablesInfo.GetSelectionInfo().

SystemType

Field 'SystemType' in table 'selection': Dictionary type Enum, .NET type: SelectionSystemType

Selection system type - defines if this selection is one that is managed by the system, and what kind it is

Declaration

public SelectionSystemTypeFieldInfo SystemType { get; }

Property Value

Type	Description
SelectionSystemTypeFieldInfo

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 TablesInfo.GetSelectionInfo().

TargetTableNumber

Field 'targetTableNumber' in table 'selection': Dictionary type TableNumber, .NET type: short

Table number that this is a selection of (contact, sale, appointment, ....)

Declaration

public UInt16FieldInfo TargetTableNumber { 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 TablesInfo.GetSelectionInfo().

TextId

Field 'text_id' in table 'selection': Dictionary type FK, target: Text, .NET type: int

Description text

Declaration

public Int32FieldInfo TextId { 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 TablesInfo.GetSelectionInfo().

TextId_InnerJoin_Text

Generated join from the foreign key TextId in this table, to its target table TextTableInfo.

Declaration

public TargetedInnerJoin<TextTableInfo> TextId_InnerJoin_Text { get; }

Property Value

Type	Description
TargetedInnerJoin<TextTableInfo>

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 TablesInfo.GetSelectionInfo().

Updated

Field 'updated' in table 'selection': 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 TablesInfo.GetSelectionInfo().

UpdatedAssociateId

Field 'updated_associate_id' in table 'selection': Dictionary type FK, target: Associate, .NET type: int

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 TablesInfo.GetSelectionInfo().

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 TablesInfo.GetSelectionInfo().

UpdatedCount

Field 'updatedCount' in table 'selection': Dictionary type UShort, .NET type: short

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 TablesInfo.GetSelectionInfo().

Visibility

Field 'visibility' in table 'selection': Dictionary type UShort, .NET type: short

Obsolete, but still maintained denormalization of visiblefor

Declaration

public UInt16FieldInfo Visibility { 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 TablesInfo.GetSelectionInfo().

Implements

ICloneable

Extension Methods

EnumUtil.MapEnums<From, To>(From)

Converters.MapEnums<From, To>(From)