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 AUDIT LOG
Auditing is disabled for all entities by default. It has to be turned on on an entity (DataEntity) level - by setting the AuditingType property.
You can exclude certain fields from being audited - by setting the ‘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 changed fields 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 |