We need to be able to explore the edit history of objects in ways that the Edit history widget does not support. Specifically we need to be able to:
- View the full detailed edit history of a single object (Edit history does support this)
- Find all recently created/updated/deleted objects of a particular type
- Find all creation/updates/deletions performed by a particular user
Is a reasonable way to do this to use action logs combined with an Interface to make action logs queryable in aggregate? (is this even possible?). We’re cautious about using action logs as (similar to this) have experienced fragility on schema changes.
An alternative we’ve considered is to have some sort of generic Event object that links to all of the object types we want to audit and we use a automate to create events on create/update/delete.
What is the best way to implement this functionality?