Audit Trail

Last modified: May 25, 2023

1 Introduction

The Audit Trail module creates a log history for the changes made to objects in your Mendix application.

1.1 Typical Use Cases

This module keeps keep track of what changes are made in your Mendix application as well as when, by whom, and how much.

1.2 Features

  • Keep track of objects that are created, changed, or deleted
  • Only save changes made on an object that has the AuditTrail.AudittrailSuperClass as a superclass and where the commit is done with an event (this could be a performance risk for apps with too many entities or records)
  • Add a commit event which analysis and save the changes
  • Log the complete state of the entity (all attributes) or only the changed attributes by modifying a constant

2 Configuration

The two sections below describe the two options for configuring this module.

2.1 Associations and Events

For this configuration option, add a reference set association from your entity to the Log entity or an association from the Log entity to the entity that needs to be audited. Add a before-commit and before-delete event to your entity that is identical to the events on the AudittrailSuperClass. The Java actions will automatically create the log item and all the required log lines based on the changes.

Next, configure the IncludeOnlyChangedAttributes constant for whether you want to log all the attributes or just the changes.

Finally, add the LogOverviewSnippet snippet to a page in a custom module.

2.2 Inheritance

For this option, all the objects you want to log need to have the AuditTrail.AudittrailSuperClass as a superclass (note that this is not possible for subclasses of the System.User object). The module will then automatically log all the changes on the create, commit, and delete events.

Next, configure the IncludeOnlyChangedAttributes constant for whether you want to log all the attributes or just the changes.

Finally, add the LogOverviewSnippet snippet to a page in a custom module.

3 Changing Audit Behavior

Changing the audit behavior is easily done by altering the values of the constants below (for module version 7.6.0 and above; please note that if no value is set, the default is used) or the default values of the Configuration entity in the module’s domain model (for module version 7.5.0 and below):

  • IncludeOnlyChangedAttributes (default: false) – This determines if the module should create a log line for every single member every time it initiates the Audit, or if it should only log the changed members.
  • LogAllMembersOnCreate (default: true) – This property only affects the scenario when IncludeOnlyChangedAttributes is false. This indicates if the application will create a log line for all attributes when the record is created.
  • IncludeCalculatedAttributes (default: false) – This determines if the module should resolve calculated attributes and compare if the result has changed since the last commit.
  • CreateLogObjectWithoutMemberChanges (default: false) – If none of the members have been changed, this property determines whether a commit will still generate a log record populated only with the changed date and changed by fields.
  • LogLineDateFormat (default: MM/dd/yyyy) – This constant determines the format to be used to convert date attributes to strings. It uses the same pattern as used by the parse and format date function calls.
  • LogServerTimeZoneDateNotation (default: true) – This determines if the date should be audited in the ServerTimeZone. If both the session time zone and ServerTimeZone are enabled, you will see two dates in the audit overview.
  • ServerTimeZone (default: UTC) – This the time zone in which the server time zone is printed. This will be a static time zone and should match the notation as used in Java (for an example, see TimeZones in Java).
  • LogSessionTimeZoneDateNotation (default: false) – This determines if the date should be audited in the session time zone of the user that makes the change. If both the session time zone and the server time zone are enabled, you will see two dates in the audit overview.