• Share
    • Twitter
    • LinkedIn
    • Facebook
    • Email
  • Feedback
  • Edit
Show / Hide Table of Contents

History Table (53)

Some tooltip text!
• 1 minute to read
 • 1 minute to read

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 Null
history_id Primary key PK
associate_id Owner of history list FK associate
table_id Table this is a history of TableNumber
record_id Record within the table RecordId
extra_id Extra ID, used to manage multiple histories per table Id
rank Sort order, indexed so it can used for sorting in the query UShort
updatedCount Number of updates made to this record UShort

History table relationship diagram

Indexes

Fields Types Description
history_id PK Clustered, Unique
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.
© SuperOffice. All rights reserved.
SuperOffice |  Community |  Release Notes |  Privacy |  Site feedback |  Search Docs |  About Docs |  Contribute |  Back to top