Class DBC.HistoryFields

Fields for History, History lists for lists and searchable controls. Maintains history for Navigator or other search (find dialogs). A single table may have more than one record here, as indicated by the extra_id field. The HistorySize (preference may be set in maintenance client) defines how many records you can have in a history list.

Inheritance

Object

DBC.HistoryFields

Namespace: SuperOffice.CRM.Data

Assembly: SoDataBase.dll

Syntax

public static class HistoryFields : Object

Fields

AssociateId

History.AssociateId: Owner of history list

Declaration

public const string AssociateId = "associate_id"

Field Value

Type	Description
String

ExtraId

History.ExtraId: Extra ID, used to manage multiple histories per table

Declaration

public const string ExtraId = "extra_id"

Field Value

Type	Description
String

HistoryId

History.HistoryId: Primary key

Declaration

public const string HistoryId = "history_id"

Field Value

Type	Description
String

Rank

History.Rank: Sort order, indexed so it can used for sorting in the query

Declaration

public const string Rank = "rank"

Field Value

Type	Description
String

RecordId

History.RecordId: Record within the table

Declaration

public const string RecordId = "record_id"

Field Value

Type	Description
String

TableId

History.TableId: Table this is a history of

Declaration

public const string TableId = "table_id"

Field Value

Type	Description
String

UpdatedCount

History.UpdatedCount: Number of updates made to this record

Declaration

public const string UpdatedCount = "updatedCount"

Field Value

Type	Description
String