Table of Contents | ||
---|---|---|
|
Description
Sometimes when working with sensitive data we need to have a list of changes on a given record in order to track down when a given change was made. This example will demonstrate how this can be performed. We'll start from the builtinDS sample, to which we'll add an additional DataSource which will be audited and we'll change the user interface in order to display the list of changes in a second (newly added) grid each time a row is selected.
Please note that from version 4.1 / 9.1 and later, the DataSource auditing is a built-in feature. For more information, follow this link.
Creating the audited and the audit trail DataSources
...
Attribute | New value |
---|---|
ID | supplyItemAudited |
tableName | supplyItemAudited |
dbImportFileName | supplyItemAuditedLarge.data.xml |
(Small side note: although the sample has the absolute path for dbImportFileName, when importing the DataSource it is possible the import tool won't see the test data unless it has been correctly specified in the table)
...
Also, note that you can filtering in the second row and by clicking calendar icon next to the timestamp field, you can filter to a specific time date range:
An Eclipse project can be downloaded from here: builtinds-Audit.zip
...