Table auditing
The audit property of the collection dictionary entry can be used to monitor and track all changes to a record. If auditing is enabled for a table, then the system tracks insertion, update, and deletion of all records in the table. Let's enable auditing in the Booking Request table.
To enable auditing for the Booking Request table, open the dictionary entry for the table (collection) as described previously in the chapter. Now, check the Audit checkbox, as shown in the following screenshot, and click on the Update button:
Once the auditing is enabled on a table, the platform tracks all changes to a record and stores all changes to the sys_audit table. The sys_id of the record that changed is tracked, along with the following other information:
- Name of the table that contains the record that changed (table name)
- Name of the field that changed (field name)
- The new field value (new value)
- The old field value (old value)
- Number of times this record and field have been updated
- The date...