Skip to Content (Press Enter)
Back to Ideas
6
Like
Follow Idea
Automatic Tracking of Data Changes
258Views
2Comments
New
Database

Hello Community,

Hopefully this is a new entry in OS' idea space.

Applied Systems' idea is to add data change tracking to database entitiy rows as an integral part of  the system. The fields would be

  • CreatedBy
  • CreatedByDateTime
  • LastChangedBy
  • LastChangedByDateTime

These fields would be automatically populated as the data within the table's row is created or updated. It would also free up application developers from having to create this functionality.

Thanks for reading,

Applied Systems



16 Apr 2020
Copy link to comment
Changed the category to
Database
11 Nov 2021
Copy link to comment
Merged this idea with 'System entities auditing' (created on 19 Dec 2023 09:27:41 by Damian Fonville)
20 Dec 2023
Copy link to comment

Include CreatedBy, CreatedDateTime, UpdatedBy and UpdatedDateTime to system entities, for example: 

  • User
  • Group
  • Group_Role
  • Group_User
  • User_Role
  • Group_User

Maybe there are more entities, but this is the list I know of. 

19 Dec 2023
Copy link to comment