Class DiaryViewTableInfo

Table 'DiaryView': Configuration of a multi-user diary view

Inheritance

System.Object

TableInfo

DiaryViewTableInfo

Implements

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

System.Object.Equals(System.Object)

System.Object.Equals(System.Object, System.Object)

System.Object.ReferenceEquals(System.Object, System.Object)

System.Object.GetHashCode()

System.Object.GetType()

System.Object.MemberwiseClone()

Namespace: SuperOffice.CRM.Data

Assembly: SoDataBase.dll

Syntax

[DatabaseTable("DiaryView")]
public class DiaryViewTableInfo : 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 DiaryView in the database dictionary: DiaryView

Declaration

public const string DictionaryTableName = "DiaryView"

Field Value

Type	Description
System.String

Properties

AssocId

Field 'assoc_id' in table 'DiaryView': Dictionary type FK, .NET type: System.Int32

Owning associate

Declaration

public Int32FieldInfo AssocId { get; }

Property Value

Type	Description
Int32FieldInfo

AssocId_InnerJoin_Associate

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

Declaration

public TargetedInnerJoin<AssociateTableInfo> AssocId_InnerJoin_Associate { get; }

Property Value

Type	Description
TargetedInnerJoin<AssociateTableInfo>

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

DiaryViewId

Field 'DiaryView_id' in table 'DiaryView': Dictionary type PK, .NET type: System.Int32

Primary key

Declaration

public Int32FieldInfo DiaryViewId { get; }

Property Value

Type	Description
Int32FieldInfo

DictionaryTableNumber

Table number for table DiaryView 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
System.Int32

ExtraInfo

Field 'extraInfo' in table 'DiaryView': Dictionary type String[255], .NET type: System.String

Extra information, whatever it might be

Declaration

public StringFieldInfo ExtraInfo { get; }

Property Value

Type	Description
StringFieldInfo

LeftOuterJoin_DiaryViewRow_DiaryViewId

Generated left outer join from the primary key DiaryViewId on this table, to DiaryViewRow.DiaryViewId.

Declaration

public TargetedLeftOuterJoin<DiaryViewRowTableInfo> LeftOuterJoin_DiaryViewRow_DiaryViewId { get; }

Property Value

Type	Description
TargetedLeftOuterJoin<DiaryViewRowTableInfo>

Name

Field 'name' in table 'DiaryView': Dictionary type String[255], .NET type: System.String

The name of the view (defined by the user during saving)

Declaration

public StringFieldInfo Name { get; }

Property Value

Type	Description
StringFieldInfo

Rank

Field 'rank' in table 'DiaryView': Dictionary type UShort, .NET type: System.Int16

Sorting rank

Declaration

public UInt16FieldInfo Rank { get; }

Property Value

Type	Description
UInt16FieldInfo

Registered

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

Registered when

Declaration

public DateTimeFieldInfo Registered { get; }

Property Value

Type	Description
DateTimeFieldInfo

RegisteredAssociateId

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

Registered by whom

Declaration

public Int32FieldInfo RegisteredAssociateId { get; }

Property Value

Type	Description
Int32FieldInfo

RegisteredAssociateId_InnerJoin_Associate

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

Declaration

public TargetedInnerJoin<AssociateTableInfo> RegisteredAssociateId_InnerJoin_Associate { get; }

Property Value

Type	Description
TargetedInnerJoin<AssociateTableInfo>

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

Tooltip

Field 'tooltip' in table 'DiaryView': Dictionary type String[255], .NET type: System.String

Tooltip shown in dropdown list

Declaration

public StringFieldInfo Tooltip { get; }

Property Value

Type	Description
StringFieldInfo

TzLocationId

Field 'tzLocationId' in table 'DiaryView': Dictionary type FK, .NET type: System.Int32

Default timezone location for this view

Declaration

public Int32FieldInfo TzLocationId { get; }

Property Value

Type	Description
Int32FieldInfo

TzLocationId_InnerJoin_TZLocation

Generated join from the foreign key TzLocationId in this table, to its target table TZLocationTableInfo.

Declaration

public TargetedInnerJoin<TZLocationTableInfo> TzLocationId_InnerJoin_TZLocation { get; }

Property Value

Type	Description
TargetedInnerJoin<TZLocationTableInfo>

Updated

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

Last updated when

Declaration

public DateTimeFieldInfo Updated { get; }

Property Value

Type	Description
DateTimeFieldInfo

UpdatedAssociateId

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

Last updated by whom

Declaration

public Int32FieldInfo UpdatedAssociateId { get; }

Property Value

Type	Description
Int32FieldInfo

UpdatedAssociateId_InnerJoin_Associate

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

Declaration

public TargetedInnerJoin<AssociateTableInfo> UpdatedAssociateId_InnerJoin_Associate { get; }

Property Value

Type	Description
TargetedInnerJoin<AssociateTableInfo>

UpdatedCount

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

Number of updates made to this record

Declaration

public UInt16FieldInfo UpdatedCount { get; }

Property Value

Type	Description
UInt16FieldInfo

VisibleColumns

Field 'visibleColumns' in table 'DiaryView': Dictionary type UShort, .NET type: System.Int16

The number of columns to actually show in this view (as opposed to the number of columns defined)

Declaration

public UInt16FieldInfo VisibleColumns { get; }

Property Value

Type	Description
UInt16FieldInfo

Implements

System.ICloneable

Extension Methods

EnumUtil.MapEnums<From, To>(From)

Converters.MapEnums<From, To>(From)