I understand from the documentation that Verj.io when updating a table for each row automatically only applies the changes on rows/fields (insert, modify, delete) when using assisted sql.
Is there a way to hook in to this to have the changes (with some additional user related metadata) also inserted in a separate 'audit trail' table?
Audit trail on changes in table
Moderators: Jon, Steve, Ian, Dave
-
- Moderator
- Posts: 1342
- Joined: Wed Sep 12, 2007 12:49 pm
Re: Audit trail on changes in table
You could try changing the Assisted SQL to Native SQL (click on Build from assisted SQL to generate the SQL statements). Then you can modify the SQL statements. Some databases allow you to enter multiple SQL statements in each box separated by a semicolon. I've never tried this but it might be worth a try.
0 x
-
- Ebase User
- Posts: 68
- Joined: Wed Aug 15, 2012 1:22 pm
Re: Audit trail on changes in table
We do some auditing on tables in SQL using triggers, so it is handled outside of Ebase and it seems to work very well. Not sure if this would be suitable for you as you mention that you want some extra metadata, but if that data is in the database, triggers could work for you.
0 x
-
- Ebase User
- Posts: 86
- Joined: Thu Mar 08, 2018 2:52 pm
Re: Audit trail on changes in table
Thank you, this could be an elegant solution. I will need to have a look at this. I'm not that a guru. Maybe there are some examples available somewhere.
0 x
Who is online
Users browsing this forum: No registered users and 11 guests