Hi,
Does Novulo have a component or maybe something in the platform to keep track of added/deleted and modified records in the database ?
Ideally we would like to see which records were added and deleted and for modfications which fields in the record were modified with the old value and new value. And for all adds/deletes and modifications a datetime stamp and userid.
@ArnoldT, hello! Maybe these posts could be useful (at least to start with): Best practices to identify changes to products, in order to synchronize them with other systems and Best practice: Application Log or Mutation (change log)
Hi Kate,
Thanks for your reply but I cannot detemine from these posts whether Novulo has or does not have a standard log mechanism for keeping track of these changes.
@ArnoldT, good morning! The default log mechanism is described here: Creating application logs for your processes. The core component is M6615.
Hey Arnold,
we do not have a tool that simply logs all deletions of all records in the application. The approach would be to add the creation of an application log manually for each record type that you are interested in.
I would suggest adding a custom logging process to the “Before delete” data process of the record that you want to monitor.
This way, right before a record is being deleted, the user, the ID and the timestamp are being tracked.
Your request suggests that you might have issues with records that are being deleted, or maybe not fully deleted.
If you struggle to also delete “underlying” records when deleting top level records, then you should consume the process “TMP_Delete records helper” and use it instead of the “Delete” action in the architect.
If records are deleted even if it should not be the case, you can add delete rules to prevent that.
Let me know if that helps or if you want to know more.
Hi Joachim,
Thanks for your answer.
Building this for every table would be a lot of work, I was hoping for a general platform solution.
A tool like this would make it easier to prove to accountants when and who did certain modifications (not just the last modification) and what was modified.
The platform team will visit us in November so I will make a note to discuss this.