Child pages
  • Implementing Audit Logging

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

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.

upper-roman
Table of Contents
style
Stoc

Configuring Audit Logging

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.

...

To log any changes or views for a table, open the table in the table editor (crossreferece here), select the security tab, select the group, and enable the Tracking and/or Tracking views option.  If Tracking option is enabled any adds, edits, or deletes to the table will be tracked for the selected group. If Tracking views is enabled any views of data to the table will be tracked for the selected group (Tracking views was added in Servoy 6.0.2 release).

Using Audit Log Data

As the log table is simply another database table, a developer can builds 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.

...