Audit Trail

Certified Lead Developer
We have a requirement to create an audit trail in our app that captures every change made on each record at the field level. In addition, we also need to store the original and new value of the field. This is goes beyond the typical audit trail use case that captures the key activities and milestones, not necessarily every data value modified.

We're considering creating DB triggers on the tables storing record data and writing every change to a AUDIT table.

Have others built a similar audit trail? Any recommendations and best practices that can be shared, would be recommended.

OriginalPostID-230702

  Discussion posts and replies are publicly visible

Parents
  • 0
    Certified Lead Developer
    Thanks Abhi. I'm familiar with the Audit History App. It doesn't quite meet the needs of our use case, which includes auditing at a field level. The Audit History App and the typical Audit Trail use cases audit at the event/action type level like Created, Approved, etc. We want to be able to log the original and new value for each data value modified.

    For example, in a record of Customers, if the name and address was updated, we need to have the original and new values of the two fields in the audit history.
Reply
  • 0
    Certified Lead Developer
    Thanks Abhi. I'm familiar with the Audit History App. It doesn't quite meet the needs of our use case, which includes auditing at a field level. The Audit History App and the typical Audit Trail use cases audit at the event/action type level like Created, Approved, etc. We want to be able to log the original and new value for each data value modified.

    For example, in a record of Customers, if the name and address was updated, we need to have the original and new values of the two fields in the audit history.
Children
No Data