Database audit trailing
To enable audit logs for databases you need to create a new table for auditing and then enable audit logs option at the extension level.
Create a new table for auditing
Before using audit logs, you need to create a new table in your database to store the logs. The structure of this table must be the same as the writeback table with 3 additional columns: ActionAt, ActionBy and ActionType.
Column | Type | Description |
ActionAt | datetime | Date and time when the action was performed |
ActionBy | string | Which user performed the action (UserDirectory\UserId) |
ActionType | string | What action was performed ( C = create, U = update, D= delete ) |
Enable audit logs in the extension
1. Open the properties panel and click on the Data Connections section
You need to set up a connection before enabling logs
2. Go to the Enable audit logs option
3. Click on the switch control to enable audit logs
4. Enter the name of the log table (e.g. Customers_log)
Last updated