Configuring Data Change History

Summary

Set how Data Change History works and what is tracked

Data Change History is configured in the Data Change History Options section of Adaptable Options.

It includes all the properties required to set up tracking changes to meet your requirements.

Making Active by Default

By default Data Change History tracking is inactive, and needs to be explicitly activated in the UI.

This can be changed via the activeByDefault property.

activeByDefault

Default: false

Boolean

Whether Data Change history should be Active by default

Limiting Data Changes

Another useful property is showDataChange which allows you to specify which data changes to monitor.

Hint

This is useful when want to display changes only in certain columns or user edits and not ticking data changes

showDataChange

Function which specifies which Data Changes should be displayed in Data Changes Monitor

This function provides details of the Data Change and lets developers specify whether that change should be included in the Data Change screen.

Note

The default value is undefined - which means that by default all data changes are logged

showDataChange?: (cellDataChangedInfo: CellDataChangedInfo) => boolean;

The function receives a CellDataChangedInfo object (defined below) and returns a boolean:

Property	Description
changedAt	Timestamp of change occurrence (in milliseconds)
column	Column in which cell is situated
newValue	New value for the cell
oldValue	Value in the Cell before the edit
primaryKeyValue	Primary Key Column's value for the row where edited cell is situated
rowData	Data in the Row
rowNode	AG Grid RowNode that contains the cell
trigger	What triggered the change - user, background change or a reverted change?

For instance to monitor only user edits (and not 'ticking' data changes) you can do:

const adaptableOptions: AdaptableOptions = {
  dataChangeHistoryOptions: {
    showDataChange: (cellDataChangedInfo: CellDataChangedInfo) => {
      return cellDataChangedInfo.trigger == 'edit';
    },
  },
};

Data Change History: Limiting Changes

Fork Fork

In this example we have provided an implementation for the showDataChange function
It is configured so that the Data Changes Monitor will not show:
- just data (and not ticking) edits
- and data edits for the Updated or Language columns

See the configured Data Change History Options properties

dataChangeHistoryOptions: {
  activeByDefault: true,
  showDataChange: (cellDataChangeInfo: CellDataChangedInfo) => {
    if (cellDataChangeInfo.trigger !== 'edit') {
      return false;
    }
    return (
      cellDataChangeInfo.column.columnId !== 'updated_at' &&
      cellDataChangeInfo.column.columnId !== 'language'
    );
  },
},

Try It Out

Click the Configure button in the Data Change History Toolbar to open the Data Changes Monitor
Edit the Updated or Language column in the grid and note that the edit does not appear in the History Log

Show All Data Changes

By default only the last change for each Cell is displayed in the Data Change History Monitor.

If this behaviour is not wanted, then set the showLastDataChangeOnly property to false in order to see every change for each Cell.

showLastDataChangeOnly

Default: true

Boolean

Whether to show all changes for each cell or just the last one

This property allows you to set the Data Change History Monitor to show all changes to a Cell, rather than just the last one (the default behaviour).

// Show all changes for every Cell
const adaptableOptions: AdaptableOptions = {
  dataChangeHistoryOptions: {
    showLastDataChangeOnly: false
  },
};

Data Change History: Showing all Changes

Fork Fork

In this example we show all changes for Cells by setting showLastDataChangeOnly to true
We update Github Stars in first row 3 times and then open the Data Change History Monitor to see all the changes

PreviousData Change History Actions NextTechnical Reference