Hi team,
Wondering if anyone has had a need for what I am about to describe - and if so - how they solved it.
I have developed a membership based app that is largely “view only” except for a designated admin who can add, edit and delete membership records.
The organisation I have developed this app for has now asked for audit logs that enable them to see what records have been added, edited or deleted - and what those changes actually were. Their interest is motivated by this info sometimes being needed for court cases - where a chain of evidence may be inportant.
Ideally - the log would show one row of data per add, change or delete - with a date/time stamp.
Conscious as well that any sort of log could eat up ‘updates’ super quickly.
Any thoughts or suggestions gratefully received.
Regards,
Russ
Yeah I’ve done this, using JSON and JavaScript.
I was able to successfully store/view up to 1000 or more log events in a single JSON string. So for example, if you have a table with 1000 items, you could store 1000 log events per item (1 million log events in total) without using any additional rows. (that’s strictly not true, because you’d need a 1000 row helper table to view the logs - so 2000 rows in total to get 1 million rows of logs).
I won’t attempt to explain how it’s done, because it’s complicated.
But you can see an example below:
1 Like
Hi Darren,
Thanks for the speedy reply. It is reassuring to know it can be done.
If the customer insists that they want this I will come back to you and see if you have time to develop it for me. Is there much work involved in implementing your solution? 2 hours? 50 hours? 100 hours?
Thanks again.
Russ