Saving additional info on Log table - Servoy Audit Trail

Classic Servoy
1

Hi, I am having problems with Servoy’s built-in logging. I am trying to save additional record information when Servoy audit trail fires.

For example, Let’s say I have the following records in the log table of the log database:
TABLE_NAME | COLUMN_NAME | OLD_DATA

  1. policy_table, id_policy, 1, 2
  2. policy_table, policy_date, 1-10-10, 2-10-10

I’d like to save additional records such as policy code like the following:
TABLE_NAME | COLUMN_NAME | OLD_DATA | POLICY_CODE

  1. policy_table, id_policy, 1, 2, TX10021
  2. policy_table, policy_date, 1-10-10, 2-10-10, TX10021

I tried using log events but based on previous post it’s not possible to trigger log events. Is there another way to pursue my requirement? My other option is to move away from built-in audit trailing and make our own audit trail module, but I know there will be a performance issue as logging should be triggered on the server and not on the client side.

Any input is highly regarded.

2

check in Servoy 6, databaseManager.addTrackingInfo

3

All right. Thanks!