Inforiver
EDITable
EDITable
  • Introduction to EDITable
    • Why EDITable?
    • Supported Database Connections
  • Get Started
    • EDITable Pre-requisites
      • Admin consent for EDITable's Entra ID
        • Basic consent
        • Full admin consent
    • Install EDITable
    • Add EDITable visual
  • Getting Data into EDITable
    • Connect to Data
      • Get data
      • Assign fields
      • Configuration Steps
        • Configure source
        • Configure Columns
        • Configure Type 2 SCDs (Optional)
    • Create a Table
      • Create From Scratch
      • Use Existing Table
      • Import Data
  • Working with EDITable
    • EDITable interface
    • Manage Columns
      • General
      • Constraints
      • Lookup and Relation
      • Display
      • Import/Export Configuration
      • Add Database Column
      • Insert Column
    • Column Access Control
    • Row Identification
    • Table Operations (Insert/Update/Delete)
      • Edit data
      • Bulk Edit
      • Find and Replace
      • Insert rows
      • Insert Column
      • Import rows
      • Delete rows
      • Duplicate rows
      • Copy rows
      • Preview Changes
      • Reset Changes
    • Explore data
      • Search and filter
      • Sort and reorder
      • Show/Hide columns
      • Pin columns
      • Group Rows By
      • Summarize Column
    • Basic formatting
    • Conditional Formatting
  • Row Access Control
  • Approval Workflow
    • Review Changes - Workflow process
  • Type 2 SCDs
    • Configuring Type 2 SCDs in EDITable
  • Audit logs
  • Webhook
  • Display Settings
  • Commenting and Collaboration
    • Assign users & task status
    • View all comments & track changes
    • Comment Settings
  • Admin Portal & EDITable Console
    • Tables
    • Transaction Logs
    • Insights (Metrics)
    • Utility
      • Download Report
      • Pipeline
        • Power BI & EDITable deployment pipelines
        • Deployment in different destinations
        • Trigger deployment pipeline from external applications
        • Logs & other pipeline options
    • Manage Profile
    • Admin Portal
      • User Management
      • Settings
        • General Settings
        • Writeback Settings
          • Settings
          • EDITable managed DB
        • API token
    • Onboarding Actions
  • Formula and Functions
    • Conditional statements
      • IF
      • IFNA
      • SWITCH
    • Logical functions
      • AND
      • IN
      • ISBLANK
      • ISEMPTY
      • ISNUMBER
      • NOT
      • OR
      • XOR
    • Math functions
      • ABS
      • AVERAGE
      • AVERAGEIF
      • AVERAGEEXNEG
      • AVERAGEEXZERO
      • AVERAGEEXZERONEG
      • CEILING
      • COUNT
      • COUNTIF
      • DIVIDE
      • EVEN
      • EXP
      • FLOOR
      • LOG
      • MAX
      • MIN
      • PCT
      • POWER
    • Text formatting functions
    • Date functions
      • DATE
      • DATE.FORMAT
    • Other operators
  • Keyboard Shortcuts
  • Release Notes
    • EDITable - v1.7.5
    • EDITable - v1.7
    • EDITable - v1.6.5
    • EDITable - v1.6
Powered by GitBook
On this page
  • 1. Track Changes
  • 2. Search and Filter
  • 3. Additional Options

Audit logs

PreviousConfiguring Type 2 SCDs in EDITableNextWebhook

Last updated 6 months ago

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.

1. Track Changes

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.

2. Search and Filter

You can use the 'Search' and 'Filter' options to look for specific changes made to a specific record.

The options available are as follows:

  1. 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.

  1. Action - You can filter out records based on their type of change, such as inserted, updated with a new value, deleted, or soft-deleted.

  2. Modified By - Use this filter to display the changes made by specific members of your team.

  3. Last 30 Days - Use this filter to view the changes made in the last 30 days, or in a custom date range.

  4. Clear Filters - Click this option to clear all the applied filters.

  5. Download Logs - This option lets you download and export, or email the logs in CSV or Excel format.

3. Additional Options

  1. Last Updated Details

    • Opens two columns showing when a row was updated and by whom.

  2. Transaction Logs

    • Shows the job details contain information about the transactions made and its status.

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
Audit logs
Search and Filter the audit log
Search using row ID
Filter based on action