Audit logs
Last updated
Last updated
The audit log is a comprehensive record of all changes made to the table. EDITable's audit log is interactive and offers both search and filter options. It also allows you to download and export the logs.
This section provides information on how to access audit logs and other related features.
If Type 2 SCDs are enabled in your table, you will not be able to use the audit log feature.
Click the Audit tab to open the audit logs window.
This displays detailed information about recent changes and updates to your table, keeping track of all modifications.
The audit log provides a chronological record of transactions and actions to track all data changes in the source table as shown in the image above. This log includes the row ID of the modified record, details of the modified columns, the previous and new values, the person who made the change, the date and time of the change, and the type of modification.
The audit log captures all the significant actions performed on the table, including Insert, Update, Delete, and Soft Delete.
You can use the 'Search' and 'Filter' options to look for specific changes made to a specific record.
The options available are as follows:
Search Row ID - Enter the Row ID in this search box to search and track all changes made to a specific row. Based on the row ID the logs are dynamically filtered and displayed.
Action - You can filter out records based on their type of change, such as inserted, updated with a new value, deleted, or soft-deleted.
Approved By - When an approval system is in place, you can use this option to filter changes based on who approved them. For more information on the approval workflow, see this page.
Modified By - Use this filter to display the changes made by specific members of your team.
Last 30 Days - Use this filter to view the changes made in the last 30 days, or in a custom date range.
Clear Filters - Click this option to clear all the applied filters.
Download Logs - This option lets you download and export, or email the logs in CSV or Excel format.
Last Updated Details
Opens two columns showing when a row was updated and by whom.
Transaction Logs
Shows the job details contain information about the transactions made and its status.
