• State Not Answered
  • Replies 2 replies
  • Subscribers 12 subscribers
  • Views 2600 views
  • Users 0 members are here
Related Discussions
Home » Discussions » Data and Records

Employee Data and saving changes

erics171

Hi, 

I am creating an employee application. I have an employee CDT. One of the requirements is to save employee data changes and have a history of the changes. 

An idea to do this is to save a new employee in the CDT each time a change is made. I don't think this is a good idea, could you list out all the reasons why this is not a good idea? 

A suggested solution would be ideal too. I'm thinking a separate audit CDT is best to save the changes and who made the changes. 

Many thanks, 

Eric

  Discussion posts and replies are publicly visible

Parents
  • 0
    Hello eric,

    You can do it with a CDT as Evan mentioned. Another Idea If you create a Quick app you will see how they create the Audit history, it is everything handled in Appian as well.

    I personally like the following pattern unless you require something more complex than recording the values changes.
    In SQL we have the triggers (on update) which help us to verify when certain value is changed from there you will have the reference of the old.field and new.field values and if something changed you just insert to your audit log.

    Depending on how much information you want to have in your audit log you might need to pass it to the employee table, the code to do that is simpler.

    Jose
Reply
  • 0
    Hello eric,

    You can do it with a CDT as Evan mentioned. Another Idea If you create a Quick app you will see how they create the Audit history, it is everything handled in Appian as well.

    I personally like the following pattern unless you require something more complex than recording the values changes.
    In SQL we have the triggers (on update) which help us to verify when certain value is changed from there you will have the reference of the old.field and new.field values and if something changed you just insert to your audit log.

    Depending on how much information you want to have in your audit log you might need to pass it to the employee table, the code to do that is simpler.

    Jose
Children
No Data

© 2024 Appian. All rights reserved.