Help showing role changes in AuditTrail module please?

0
Hi all,I am trying to show an audit history table in Mendix using a simple data grid and connecting to "AuditTrail.LogLine" and using the xpath constraint " [Member = 'System.UserRoles'] " but the challenge I face when adding the columns is I can see "Name" "dateChanged" "Member (which is showing as "System.UserRoles" but for some reason I am not able to see what it changed from and to. In the table I want to see "Name (who changed it" Date/Time changed" What was changed (ie System.UserRoles) then for example "Old Value - Administrator" "New Value - User" - I have searched high and low for answers because we are not allowed to edit marketplace modules and I cannot figure out how to show it. Its definitely storing the change but it won't show it. The change is made in the administration module and I have a microflow that tracks that but it won't drop the change into the audit data grid.Any help would be appreciated.Novice Mendix user here.Thank you
asked
1 answers
0

The AuditTrail.LogLine entity mainly stores information about which member was changed (for example, System.UserRoles), but the old and new values are typically stored in the Audit Trail detail records.

If you're using the Marketplace Audit Trail module, you don't need to implement this yourself. The module already provides the required functionality.

A few things to check:

  • Ensure you've added the Audit Trail microflows (Before Commit / After Commit) to the entities you want to audit. These microflows capture the attribute changes.
  • The module includes a page/snippet called LogLineDetailsSnippet, which displays the Old Value and New Value for each audited change.
  • You can also use the provided Audit Trail Overview page instead of building everything from scratch.

The following entities are used by the module for storing and displaying the audit details:

  • BCo_AudittrailSuperClass
  • BDe_AudittrailSuperClass

If you're only displaying AuditTrail.LogLine in a Data Grid, you'll see information such as the changed member and timestamp, but not the detailed before/after values. Those come from the associated detail records displayed by LogLineDetailsSnippet.

Kindly mark this as the accepted answer if it helps.

answered