History table - SuperOffice

History Table (53)

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.

Fields

Name	Description	Type	Nullable
history_id	Primary key	PK	No
associate_id	Owner of history list	FK associate	No
table_id	Table this is a history of	TableNumber	No
record_id	Record within the table	RecordId	No
extra_id	Extra ID, used to manage multiple histories per table	Id	No
rank	Sort order, indexed so it can used for sorting in the query	UShort	No
updatedCount	Number of updates made to this record	UShort	No

Indexes

Fields	Types	Description
rank	UShort	Index
associate_id, table_id, extra_id	FK, TableNumber, Id	Index

Relationships

Table	Description
associate	Employees, resources and other users - except for External persons

Replication Flags

Copy to satellite and travel prototypes.

Security Flags

No access control via user’s Role.

Related topics

Save Histories Get History NSHistory Get Histories navigation_history table ticket_status_history table

⌘I