Skip to main content
mohank0008
mohank0008
July 13, 2022
Question

Regarding row-level auditing and field-level auditing

  • July 13, 2022
  • 6 replies
  • 0 views

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.

    6 replies

    stefanhelzle0001
    stefanhelzle0001
    Brainy
    July 13, 2022

    www.digitalocean.com/.../how-to-manage-and-use-mysql-database-triggers-on-ubuntu-18-04

      mohank0008
      mohank0008Author
      July 13, 2022

      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

      stefanhelzle0001
      stefanhelzle0001
      Brainy
      July 13, 2022

      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.

      stewart.burchell
      stewart.burchell
      November 2, 2022

      Hi Mohan - I try to consider the big picture here. What is the actual business requirement? Who needs to be able to see the audit data? What should it contain? How long does it need to be kept for? Do they need to see a full "before and after" view of every change? Or only certain changes? Do you need a full history, or just details on who and when the last change was made? There's way more to this than just the one narrow technical option being asked here. 

      mohank0008
      mohank0008Author
      November 2, 2022

      Thanks for the Reply,

      I got the articles related to it, and also I had completed that one.

      Let me example you with an example,

       Here, in my case, I have a customer table.

      Row-Level Auditing: If the name of the customer is updated, then that entire record should be audited in customer_rowAudit table.

      Field-Level Auditing: If the name of customer is updated, then that field should be audited in cutomer_fieldAudit table with previous value, field name, updated value and customer ID.

      R
      ramkumarp
      May 7, 2024

      Hi Mohan,

      Could you please share the articles related to these Field Level and Row level auditing on Appian records?

      Terms & ConditionsAccessibility statement