• State Suggested Answer
  • Replies 5 replies
  • Answers 1 answer
  • Subscribers 11 subscribers
  • Views 2785 views
  • Users 0 members are here
Related Discussions
Home » Discussions » User Interface

How to audit record in Audit table

Hari Kishore Reddy

Hi,

I have a CDT and it is linked to a form and fileds are linked to CDT columns.

Now, when user submit the form, data should save in the main table as well as another Audit table.

Any idea how can I achieve this requirement.

  Discussion posts and replies are publicly visible

Parents
  • 0
    Appian Employee

    Hi Hari

    There are a few things to consider here:

    • what is the audit requirement? there are different levels of "audit":
      • simple: who changed the data and when
      • event based audit to a separate table - who did what and when
      • field-level audit - what did the whole data look like before a change and what does it look like now
    • you also need to consider who will want to view that audit, when and how - it's all very well to use trigger-based copies of the data but if you can't surface that to a specific role in a timely and easy-to-understand format then the functionality doesn't meet the requirements 
    • each of the above levels of sophistication requires different solutions, both to record the changes and also to present them
Reply
  • 0
    Appian Employee

    Hi Hari

    There are a few things to consider here:

    • what is the audit requirement? there are different levels of "audit":
      • simple: who changed the data and when
      • event based audit to a separate table - who did what and when
      • field-level audit - what did the whole data look like before a change and what does it look like now
    • you also need to consider who will want to view that audit, when and how - it's all very well to use trigger-based copies of the data but if you can't surface that to a specific role in a timely and easy-to-understand format then the functionality doesn't meet the requirements 
    • each of the above levels of sophistication requires different solutions, both to record the changes and also to present them
Children
No Data

© 2024 Appian. All rights reserved.