History of Changes on the records of an entity
Question
Application Type
Reactive
Service Studio Version
11.10.12 (Build 39003)
Platform Version
11.0.1000.1

Hello,


Could someone tell me if there is any way in Outsystems to record the changes that are made to the different entities.


For example, I have an entity where the customers are and somehow I need to be able to see:


1) When each record was created, who created it and the value of its fields.

2) Every time a change is made, I need to know what field the change was made on, old value and new value.



Thank you very much

mvp_badge
MVP

Hi Salvador,


You don't have this behavior by default nor you shouldn't in my opinion, since such tracking implies a lot of storage space and performance overhead on every database CRUD operation.

Being that said, there are some scenarios where it is critical to have such an "audit trail" and they can be implemented in the platform.

If you want to take a look at some examples, you can check out OutSystems Forge, there are a few components that showcase it in action.


Kind Regards,
João

Hi Salvador,

  you can use below forge component to fulfill your requirement.


https://www.outsystems.com/forge/component-overview/8718/audit-trail-log-changes


Thanks

CV sharma 

 



Champion

Hi Salvador,

Although this technology is not in the scope of Outsystems, the best way to achieve this is by using DB's trigger. 

Thanks

Hi Salvador Duran,

You can put log message and to find who and when created and updated the data you can add the CreatedBy ,CreatedOn,UpadatedBy UpdatedOn attributes to entity and assign Getuserid() and currtimedate().

Regards,

Komal


Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.