Addtional columns EntityLog Submenu

Hi,

Can we add specific fields to the audit_entity_log table to improve tracking and visibility for changes.

Currently, we are encountering an issue where it is difficult to identify the specific user data entity for which a change was made because if we create SQL query for export:

  1. Different entities use different column names for their ID.

  2. The instance name is set to a different field in some entities.

The audit log successfully captures the column changed, the old value, and the new value. However, if the instance annotation is set on a other column other than username, we cannot clearly see which user data record the change applies to.

Could we explore adding fields to audit_entity_log to make tracking clearly identifiable.

image

Hi, @adnan.khan

You could try to extend a data model (EntityLogItem entity), UI and Spring bean that creates EntityLogItem entities (see io.jmix.audit.impl.EntityLogImpl).
More details about extending functionality are described in the documentation.

Regards,
Maria.