Servoy provides the ability to log any data change or data read in a table in Servoy. This data is stored in a table specified in the database and can be reported, displayed, and used within a Servoy solution.
...
Configuring Servoy for audit logging is done in the database server connection pages. Any database server can contain the log table. To enable a server to be the log server, select Log Server in that database server's configuration editor.
The log table can be a table with all the other data tables for your the solution, or it could be in its own separate database server. Some reasons for having a separate database server for the log table include:
Once the database server has been decided, check the Log Server box and click the Create Log Table button. A table named "'log" ' will be created in the database server. Now audit logging is available for any table in the resource resources project (or on the application server for Servoy Server).
To log any changes or views for a table, do the following:
...
...
...
...
...
...
...
Info |
---|
Tracking views of data is HIPAA Security Rule compliant. |
As the log table is simply another database table, a developer can builds build forms against the log table to allow users the ability to read and work with the data. Data within the audit log could also be used to access any changed record in the database.
...