Audit Trail

  

Hi there,

I know that Oracle database has audit trail mechanism. What about Outsystems? If there isn't , how to create audit trail in Outsystems?

regards,

indra


Solution

Hello Indra.

If you are using OutSystems with an Oracle database, then you can activate Oracle's audit trail on top of OutSystems tables. They don't interfere with each other.

If you're using Sql Server or MySQL, similar features do exist. Again, your dba could do some research and help you out by using a standard database feature.


If you need to have an audit trail in your application, not on the database, then have a look at this forge component: https://www.outsystems.com/forge/component/374/human-readable-change-history/. It describes the differences between two records, so whenever making changes to some business entity, you can store this diff text in a separate audit table.

Solution