Post reply

Do I populate the Change Reason on the old row or the new one?

  • April 11, 2016 at 8:07 am

    #315500

    What is the best practice for where to put the change reason? Should it be on the old row, showing why the old row expired? Or should it be on the new row, showing why the new row was created? What are the compelling reasons for putting it one place or the other?

    I am currently leaning toward putting the change reason on the new row so that I can know what changed, the date it changed, and the new value after the change all without complex query logic.

  • April 12, 2016 at 10:33 am

    #1871459

    From a logical point of view, it also makes sense to me that it is stored on the new row...and that's typically the way I do it.

    One potential drawback of storing it on the "old" row is that your very first version of a particular entity will not have a previous version to add the reason to.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply