What is the purpose of the HISTORY table? 

Version 1

    Details

    What is the purpose of the HISTORY table?


    Resolution

    - The table HISTORY stores the settings per User for recently viewed items, which is set in
    1. Tools >> Options
    2. Tab System
    3. Recent Items Shown




    - The range can be set from 1 to 100, the default value of GoldMine is set to 5 recently viewed items

    - Columns of table HISTORY:
    USERID - User name
    CNT - Number of recent items to display
    RECID - unique record identifier for the entry

    - HISTORY table is part of the Contact Set tables, which means the setting can be different per contact set database

    - additional information: the recently viewed items per user are stored in the HISTORY_ITEM table (also see Knowledge Article #13288)