HOME DOCUMENTATION DOWNLOADS

Data Audit Logging

Tags: #<Tag:0x00007fed7dfbe790>

Audit log records all create/update/delete events on the data.

Every log record contains the following information:

  • Who created the log record (Id from the Address Book)
  • Date/time when the event occurred
  • Original value
  • New value
  • Original Id value (if the affected field was a lookup field)
  • New Id value (if the affected field was a lookup field)
  • Type of audit event (Added/Deleted/Updated)

HOW TO ENABLE AUDITLOG

Auditing is disabled for all the entities by default. It has to be turned on on an entity (DataEntity) level - by setting AuditingType property.

You can exclude certain fields from being audited - by setting ‘ExcludeFromAuditing’ property in a field (DataEntityColumn).

You don’t have to set anything else. Just restart the server.

DATA AUDIT EVENTS

These are the audit events that are currently being recorded:

CREATE

When a record is created, all values from the newly created record are written in the audit log.

The audit can be retrieved from the UI for each record.

UPDATE

When a record is updated, all fields that were changed are written in the log. Original and new values are recorded.

The audit can be retrieved from the UI for each record.

DELETE

When a record is deleted, all fields from the record are written in the audit log.

These records cannot be retrieved from the UI and must be manually read from the database.

Update: Certain deleted records can now be shown when configured:

TECHNICAL INFORMATION

Audit log data are written in the OrigamDataAuditLog table.

Possible values of the ActionType field:

Value Status
4 Added
8 Deleted
16 Modified
1 Like