I need some information regarding row-level auditing and field-level auditing in the cloud database.
mainly i need more info on field- level auditing, i have been searching for that from the past one day, i didn't get any syntactically correct SQL code using triggers.
you can suggest me a video / blog / website.
Thanks in Advance.
Discussion posts and replies are publicly visible
www.digitalocean.com/.../how-to-manage-and-use-mysql-database-triggers-on-ubuntu-18-04
Hi Stefan,
first of all, Thanks for your immediate response.
i am having some knowledge regarding the things that we do with triggers in general.
i need info particularly related to field-level auditing with a sample example
This is not specific to Appian in any way and we do not know what you want to achieve.
In general, my suggestion is to implement a copy-on-write mechanism using a trigger to store a copy of the old data to a separate table before insert. Then you have all versions of the data if needed.