Data Change History

Summary

  • Data Change History - monitor any changes to your data (either user or ticking)

The Data Change History Module is designed to give users an overview of all changes to the grid's data.

These are provided in the Data Changes Monitor which displays details of all cell value changes in the current AdapTable session.

This includes both direct user edits and 'ticking' data changes.

Configuring Data Change History

There are many properties in Data Change History Options to configure the Data Changes Monitor including:

  • whether to turn on change tracking by default
  • which types of data changes to display
  • whether to display a button in each change row - typically used to undo the change

Find Out More

See Configuring Data Change History for more information and associated demos

Data Change Modes

There are 4 modes for tracking Data Changes in AdapTable:

  • Off: No Data Changes are tracked

    Caution

    This is the default option - Data Change tracking needs to be explicitly turned on

  • Active: Data Changes are tracked (from the moment it went active)

  • Suspended: New Data Changes are not tracked (but previous change history still displays)

  • Inactive: New Data Changes are not tracked and all previous changes are flushed from cache

Hint

Tracking can be auto-activated by setting activeByDefault to true in Data Change History Options

Data Change History
Fork
  • This Grid mimics ticking data: every 2 seconds GitHubStars & GitHubWatchers columns update (with Flashing Cells active) and Updated column shows the current time
  • We have set activeByDefault to true in Data Change History Options, so data changes are edited from the start
Try It Out
  • Click the Configure button in the Data Change History Toolbar to open the Data Changes Monitor
  • Turn off or suspend Data Change Monitoring and see that the grid will still tick, but the edits will no longer appear in the History log
  • Edit a column in the grid (e.g. Language or Description) and see your edit in the History Log - which will show as User Edit in the Source Column

Using Data Change History

The Data Change History Monitor is designed to be used at run time.

Opening Data Changes Monitor

The Data Change History Monitor can be opened (via the Show Button) in numerous ways:

Setting Data Change History Mode

The Change History Mode can be set in each of 3 locations listed above.

Each UI Control contains 3 Buttons (the contents differ based on the current status):

  • Suspend / Resume
  • Activate / Deactivate
  • Show

Setting UI Entitlements

The Entitlements for Data Change History are:

  • Full - everything is available and visible
  • ReadOnly - the Monitor will display and show changes but it cannot be activated, inactivated or suspended
  • Hidden - the Monitor is hidden and cannot be displayed and all UI Controls are hidden

Monitoring Data Changes

(Recorded with AdapTable v13.0)

FAQ

Can I see other information in the Change History Module other than cell changes? Not at the moment, but that might be added in due course. In the meantime use the Adaptable State Changed Event for full oversight of all activity in AdapTable.