Appian Community
Site
Search
Sign In/Register
Site
Search
User
DISCUSS
LEARN
SUCCESS
SUPPORT
Documentation
AppMarket
More
Cancel
I'm looking for ...
State
Suggested Answer
+1
person also asked this
people also asked this
Replies
15 replies
Answers
2 answers
Subscribers
11 subscribers
Views
14487 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
General
Audit Trail
angadc
Certified Lead Developer
over 8 years ago
We have a requirement to create an audit trail in our app that captures every change made on each record at the field level. In addition, we also need to store the original and new value of the field. This is goes beyond the typical audit trail use case that captures the key activities and milestones, not necessarily every data value modified.
We're considering creating DB triggers on the tables storing record data and writing every change to a AUDIT table.
Have others built a similar audit trail? Any recommendations and best practices that can be shared, would be recommended.
OriginalPostID-230702
Discussion posts and replies are publicly visible
Parents
0
harrisont606
over 6 years ago
I think DB triggers are the way to go here. If you have massive inserts or updates you may face performance problems though.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Reply
0
harrisont606
over 6 years ago
I think DB triggers are the way to go here. If you have massive inserts or updates you may face performance problems though.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Children
No Data